Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

commit interval Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2008 5:18 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 4:16 AM
Points: 346, Visits: 519
We are loading about 1.8 million records from a flatfile. what should be the commit interval for loading this?

--
Sabya
Post #542523
Posted Tuesday, July 29, 2008 5:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
sabyasachi.mukherjee (7/29/2008)
We are loading about 1.8 million records from a flatfile. what should be the commit interval for loading this?

Depend on: what recovery mode you are using (you may want to switch to bulk during the load), how large the rows are, are you expecting any conflicts/ roolbacks, in case of rollbacks how much you would like to roll back, what is the size of your transaction log, how much it is growing, are you happy with the growth rate, is this happening during a busy/quiet period, ...

Regards,
Andras





Andras Belokosztolszki, MCPD, PhD
GoldenGate Software
Post #542525
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse