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

Warren · Post by **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

Serious · Post by **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.