I updated from MySQL 5.01 to 5.1 a few days ago. My Delphi application runs
on XP with 3GB ram.
I have a query #1 that executes a simple Select statement that fetches 5000
rows from a single table sorted by date. (no joins)
Inside a loop if any rows need to be updated, another query #2 will update
that row and then a Next statement goes to the next row in Query#1 and this
repeats until all the rows from the table are traversed. This seems pretty
simple and has worked fine in v5.0.1. Since upgrading to v5.1.30 after a
few hundred rows have been updated, the Next statement will hang for 60
seconds and then I get a "lost connection to mysql server" message. If I
take the updates out of the loop, it completes just fine. So why are a few
thousand updates causing a problem inside of a loop? The updates are
updating 1 row at a time and does not alter any of the keys in the table.
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
