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/[email protected]
