Re: 65600 record insert cap
Posted by: ray.greenley
Date: October 14, 2004 02:45PM

Okay, I guess I should have done all my testing before I posted, but I didn't. So sue me.

Forget table B, it's not important.

I have a loop which updates rows to a table with an auto-increment value one row at a time. Once the auto-increment value gets over 65600, the MySqlDataAdapter.Update will stop (no exceptions, just hang). If I attempt to start the loop again, it will go through about 100 records before it stops again. If I delete all the records in the table and reset the auto-increment value to 1, it will once again go to about 65600 before it stops. If I delete the records from the table and I do not reset the auto-increment value (empty table with the auto-increment starting at 65600+) then it will again stop after a few records.

Does anyone else get this behavior?

Ray G.

Options: ReplyQuote

Written By
October 14, 2004 11:54AM
October 14, 2004 02:15PM
Re: 65600 record insert cap
October 14, 2004 02:45PM
October 15, 2004 06:42AM
October 21, 2004 01:59PM

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.