We have what is called a data grabber for quotes that is inserting rows into
both InnoDb and MyIsam tables.
When the data is being imported ( inserted ), it is dramatically slowing
clients down that are running queries against the table.
Our first attempt at a solution was to insert one row
One thing you could do, which may not be the best, is insert one (or
some set limit) of rows at a time, then after each sleep for .25 seconds
or something, so that your inserts get spread out more over time, and
there is idle time between them for the selecting clients to complete.
Obviously this
PROTECTED]
Sent: Wednesday, October 13, 2004 2:02 PM
To: [EMAIL PROTECTED]
Subject: speed issue - inserts slowing down selects
We have what is called a data grabber for quotes that is inserting rows
into
both InnoDb and MyIsam tables.
When the data is being imported ( inserted ), it is dramatically