List:General Discussion« Previous MessageNext Message »
From:Feris Thia Date:December 15 2010 12:51am
Subject:Bulk Insertion Performance
View as plain text  
Hi All,

I have a data warehouse infrastructure with following configuration :
- MySQL 5.0 MyISAM + InndoDB enabled (XAMPP Distribution)
- Windows 2003 64 bit data center edition
- Java Runtime 6 - 32 bit version

And have ETL running data warehouse process. Reading is impressive, 12,000
rows per second. But writing with only 10 columns (integer and varchar
combinations) takes 3,000 rows / second.

Is there a way to configure writing to have a better performance ?

Thanks,

Feris

Thread
Bulk Insertion PerformanceFeris Thia15 Dec
  • Re: Bulk Insertion PerformanceMark Matthews15 Dec
    • Re: Bulk Insertion PerformanceFeris Thia15 Dec
      • Re: Bulk Insertion PerformanceMark Matthews15 Dec
        • Re: Bulk Insertion PerformanceFeris Thia16 Dec
          • Re: Bulk Insertion PerformanceJohan De Meersman16 Dec
            • Re: Bulk Insertion PerformanceFeris Thia19 Dec