Could not run query: Too many keys specified; max 64 keys allowed
Posted by: paul mall
Date: February 12, 2007 06:13PM

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

Options: ReplyQuote


Subject
Written By
Posted
Could not run query: Too many keys specified; max 64 keys allowed
February 12, 2007 06:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.