MySQL Forums
Forum List  »  Data Warehouse

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
datawarehouse ETL rolls back after 5 GB of data transfer
7158
shyam ahuja
May 12, 2010 10:01AM
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3461
Rick James
May 14, 2010 11:17PM
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3424
shyam ahuja
May 17, 2010 01:03PM
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3518
shyam ahuja
May 20, 2010 11:38AM
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3923
Rick James
May 20, 2010 11:05PM
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3321
shyam ahuja
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.