[PHP-DB] Re: Advanced. Optimizing querry performance on a huge db with over 2.5 million entries

Hi Andy, it is difficult to give you an advice without the knowing about how you are searching the database. But if you have to search through all entries, it was a bad decision to split them up into 250 tables. Some other hints: You are lost without an index, because mysql have to do a full

[PHP-DB] Re: Advanced. Optimizing querry performance on a huge db with over 2.5 million entries

thanx, I am gonna play with it Andy Lutz Brückner [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Andy, it is difficult to give you an advice without the knowing about how you are searching the database. But if you have to search through all