Loader.CreateColumns Slows To Almost A Stop After Table Size of 1.2 GB

Loader.CreateColumns Slows To Almost A Stop After Table Size of 1.2 GB

Postby Warren » Sat 21 May 2005 00:11

I have just purchased the mySQL.Net provider. While testing the Loader to load very large tables in large batches, I found that using Loader.CreateColumns became very very very slow. Not sure what you are using to get the column schema, but it appears to be causing an extreme number of reads when the table size grows large. I have a work around of recreating the columns manually, but it sure would be nice if the create columns was fixed.
Thanks
Warren
 

Postby Serious » Mon 23 May 2005 08:19

Thank you for the information. We have improved the MySqlLoader component so the performance has increased significantly. The changes will be included in the next release.
Serious
 


Return to dotConnect for MySQL