Looktrne Posted February 13, 2007 Share Posted February 13, 2007 Hello Im Not Sure This Is Where To Post This but I need some help I am running a php dating site http://abmatch.com It was working fine until the database became larger like 7000 members the people who wrote the script installed a php indexing file for me db_index3.php .... it went through and indexed the database After this was done the home page loaded super fast again.... but now it is slow again and when I run the db_index3.php file it comes up with this error: Could not run query: Too many keys specified; max 64 keys allowed so it can not index everything it needs to.... can someone please explain a little better how these keys are used???? could I undo the indexing of the database and re-run the indexing script?? Please anyones help on this would be greatly appreciated.... Paul abmatch.com Quote Link to comment https://forums.phpfreaks.com/topic/38243-could-not-run-query-too-many-keys-specified-max-64-keys-allowed/ Share on other sites More sharing options...
btherl Posted February 13, 2007 Share Posted February 13, 2007 Can you post that indexing script here? There must be something unusual about the database design that makes it run out of keys for such a small data set. Quote Link to comment https://forums.phpfreaks.com/topic/38243-could-not-run-query-too-many-keys-specified-max-64-keys-allowed/#findComment-183195 Share on other sites More sharing options...
fenway Posted February 13, 2007 Share Posted February 13, 2007 You seriously have >64 indexes in a single table? Something is very wrong here.... Quote Link to comment https://forums.phpfreaks.com/topic/38243-could-not-run-query-too-many-keys-specified-max-64-keys-allowed/#findComment-183623 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.