Do simultaneous inserts and selects slow down a query?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sameerpanjwani
    New Member
    • Aug 2008
    • 2

    #1

    Do simultaneous inserts and selects slow down a query?

    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?
  • coolsti
    Contributor
    • Mar 2008
    • 310

    #2
    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

    • mwasif
      Recognized Expert Contributor
      • Jul 2006
      • 802

      #3
      Converting table to InnoDB might help you, but keep in mind that InnoDB is more resouce intensive.

      Comment

      Working...