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

Update command taking long time to execute Expand / Collapse
Author
Message
Posted Tuesday, August 26, 2008 2:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 28, 2009 10:48 AM
Points: 15, Visits: 97
I am using update command under OLEDB command transformation to update existing records but it is taking long time to update mearly 10000 records. Why it is so. ?

Post #558675
Posted Tuesday, August 26, 2008 5:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:35 AM
Points: 7,197, Visits: 6,342
The OLE DB Command in Data Flow works on a Row By Row basis. RBAR at its finest. @=)

If you have something huge to update, you're better off trying to figure out how to accomplish it in an Execute SQL Task. What I do is read my data into a Staging table with the Data Flow, then run an Execute SQL Task and, depending on the situation, either use the Execute SQL Task to upload the data to the final destination or return to a second Data Flow to finish my transformations.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #558745
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse