MySQL cache
Posted by:
Sean
Date: July 14, 2005 10:59AM
I have a web crawler that is obvousily very active with thousands of entries removed and added every hour. My own software takes care of that part and every 8 hours I load its current state to a MySQL table. There are about 6 different ways the users can sort the results, and with sorting it takes almost an additional second to do the search. Is there a way when I load the table to have MySQL cache all 6 possible ways of sorting the database so it doesn't have to do the processing for each individual request?
Subject
Written By
Posted
MySQL cache
July 14, 2005 10:59AM
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.