Daniel, also consider selecting as high priority. That will cause select queries to jump ahead of pending insert queries. That will allow each select to only have to wait for at most one insert to complete.
Cheers, -Dana -----Original Message----- From: Daniel Cummings [mailto:[EMAIL 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 slowing clients down that are running queries against the table. Our first attempt at a solution was to insert one row at a time. This doesn't seem to make a difference. The next thing we tried is the "Insert Delayed" which as I stated in an earlier post, doesn't seem to work for InnoDb tables. We are also looking at "Insert Low_Priority". Does anyone have any suggestions? TIA Dan ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Stores, Inc. Confidential ********************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
