MySQL Forums
Forum List  »  Data Warehouse

Re: datawarehouse ETL rolls back after 5 GB of data transfer
Posted by: shyam ahuja
Date: May 17, 2010 09:26PM

Thanks Rick for your suggestion! I did change my script to commit at small intervals. Performance is issue for me here. It starts well with quick transform of data but then it degrades and goes very slow. I do have indexes on key fields. Any suggestions will be greatly appreciated!

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3321
May 17, 2010 09:26PM


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.