Re: 65600 record insert cap

[ray.greenley]

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?

Thanks,
Ray G.