Page 1 of 1

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

Posted: Sat 21 May 2005 00:11
by Warren
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

Posted: Mon 23 May 2005 08:19
by Serious
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.