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


Subject
Views
Written By
Posted
A very odd ODBC problem: Mysql connection busy
9490
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.