I've been facing problems with a query which I think is relatively well optimized but has been performing really slow as of late as the size of the table has increased to more than 1GB. The MyISAM table is updated every few seconds, only a few rows, and a different set of rows are selected every few seconds.....would that cause a slowdown and if so, what is the solution?
No announcement yet.
Do simultaneous inserts and selects slow down a query?Page Title Module
Move Remove Collapse