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.....wou ld that cause a slowdown and if so, what is the solution?
Do simultaneous inserts and selects slow down a query?
Collapse
X
-
Tags: None
-
Can you carry out some of the insert or select queries yourself manually at a console window? Then you can see for yourself which queries, if any, are working slowly. You can use the EXPLAIN keyword to see if there is any indication that too many rows in a query are being examined in the tables, giving you an idea for further optimization by adding indexes.
Remember that just adding a lot of indexes may not be a good idea, as the indexes will speed up selects but will slow down inserts. And will make extra tables that also may be large.
Comment