burhankhan Posted August 22, 2007 Share Posted August 22, 2007 Hi: I have a database of members with 3 Million records. Its size is 400 MB. When i query to get records from that database, it takes too much time (2, 3 seconds) and server become busy when there are some queries from that database. I searched its solution, and found that i should split that database into many tables. How can i do this? There are primary keys (ID) into that table, if i will split it, how can i manage it using php? Or is there any other solution? Thanks Burhan Khan Quote Link to comment Share on other sites More sharing options...
fenway Posted August 23, 2007 Share Posted August 23, 2007 Depends how it's queried. Quote Link to comment Share on other sites More sharing options...
burhankhan Posted August 23, 2007 Author Share Posted August 23, 2007 Depends how it's queried. What is general solution for a big database? If there are 10 queries in every second from that database, how we can manage it? Ofcourse server will got down, when it spends 3 seconds in each query. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 23, 2007 Share Posted August 23, 2007 No such thing as a general solution . How much info is being queried? How much of the table, etc.? Which fields, indexable, etc.? Quote Link to comment Share on other sites More sharing options...
burhankhan Posted August 23, 2007 Author Share Posted August 23, 2007 No such thing as a general solution . How much info is being queried? How much of the table, etc.? Which fields, indexable, etc.? Some time 30,000 records need to be fetch, some time only one record. And some time need to count number of records in it using Count(*). It is only one table that is making problem. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 27, 2007 Share Posted August 27, 2007 And what where clauses are being used to query it? Indexes, etc.? For the counts, you can probably use summary tables. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.