Re: Sudden drop in read performance
I recreated the table using the InnoDB engine which is defiantly faster. Queries are coming back in 3 to 4 seconds rather than 10 to 13 but still not as fast as before.
However I also dropped and re-created the primary key and index on the original table which using the MyISAM engine and queries are coming back as fast as they used to.
Do the indexes need to be rebuilt occasionally on MyISAM tables?
Subject
Views
Written By
Posted
2526
May 22, 2012 08:23PM
1383
May 23, 2012 11:18PM
1156
May 24, 2012 06:36AM
Re: Sudden drop in read performance
1230
May 30, 2012 05:55AM
1241
June 12, 2012 11:03PM
1027
July 06, 2012 08:28PM
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.