What type of select is this? Is the application and the database on the same machine? Is this query build a large temp table?
-----Original Message----- From: John Nairn To: [EMAIL PROTECTED] Sent: 7/14/04 7:11 PM Subject: Any select with a large result set locks all other threads until it completes. Any suggestions? Hi, I am testing mysql on a large database (10GB). When I post a large select request via myodbc all other process threads lock until that thread completes. I am not locking any tables. How do I stop a read only select statement with a large result set from locking all the other threads until it completes? I am using version mysql 3.23.56 with odbc 2.5 and mysql tables. All the best. John Nairn Readysell Pty Ltd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
