65600 record insert cap
Posted by: ray.greenley
Date: October 14, 2004 11:54AM

I'm not 100% confident that this issue resides with Connector/Net, but it seems to be the only logical place.

I'm adding many records to a MySql database for testing purposes. I have a loop which populates a dataset with 1000 records in table A and about 2500 records in table B in each iteration, with the goal of getting 100,000 records in table A and 250,000 records in table B, and updates those records to the database using MySqlDataAdapter.Update. After each Update, I clear all records from the dataset to conserve memory.

The problem comes in after records 65000 to 66000 of table A are loaded into the dataset, and I try to Update those records back to the database. Once the 65600th record is loaded, the update stops. MySql is still alive, but all activity relating to the update thread halts, and the app that is executing the update sticks on the MySqlDataAdapter.Update line.

When I try to re-execute my app, only 65 records are added to the DB before the same behavior happens again.

I've double-checked my data types in both the MySql table and in my app, and I can't find anything that could possibly be overflowing. Does this sound like anything that anyone out there has heard of before? Anyone have an idea of what's going on?

Ray G.

Options: ReplyQuote

Written By
65600 record insert cap
October 14, 2004 11:54AM
October 14, 2004 02:15PM
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.