A very odd ODBC problem: Mysql connection busy
Posted by: gregory west
Date: August 21, 2009 10:03AM

I have a Foxpro V9 sp2 program. It does 70,000+ updates to a MySQL table. Problem is the first update causes the cursor in MySQL to become busy for anywhere up to 5 minutes. I do a suspend in foxpro and wait, then do a resume and the last 70,000+ records are processed in the matter of seconds.

Any idea what would be causing this to happen?

Options: ReplyQuote

Written By
A very odd ODBC problem: Mysql connection busy
August 21, 2009 10:03AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.