MySQL Forums
Forum List  »  Data Warehouse

Re: datawarehouse ETL rolls back after 5 GB of data transfer
Posted by: shyam ahuja
Date: May 20, 2010 11:38AM

Hi,

I could run ETL for about 55 hours to transform into 44 GB of one table which is joins of multiple tables. I did changed my earlier ETL script to commit after 10,000 rows which made it fast as compare to commiting after complete transform.

I will be using this table for mostly selects to run reports. Can anyone suggest how can I tune my parameters to run faster? I installed with following options
1. Server
2. multifunction
3. OLTP

please let me know if you need more information.

thanks in advance!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3517
May 20, 2010 11:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.