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
