On Dec 14, 2010, at 6:51 PM, Feris Thia wrote: > 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 ?
Feris, *How* are you writing, via batch statements with rewriting, or directly, or via LOAD DATA INFILE? It seems you're off by about a factor of 10-20x from what I've seen performance-wise for writes. -Mark -- Mark Matthews Principal Software Developer - MySQL Enterprise Tools Oracle http://www.mysql.com/products/enterprise/monitor.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org