Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing massive update
Message
De
31/03/2015 23:08:55
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01617566
Message ID:
01617573
Vues:
31
>I think that the save is going to be significant, but it's up to you to test.

Presently, it takes 0.0156 second for an update to be done. When I multiple that for a batch of 100 records, this takes 1.56 seconds. If a batch update of 100 records can be done in 0.5 seconds for example, that would represent something along a 1 second save for every 100 records representing a saving of about 10000 seconds for 1 million records. That would be a saving of about 3 hours. I have 4 million records to process. If I could reach this target, this would be a saving of about 12 hours. Presently, the entire process is schedule to take 55 hours. So, I could bring it down to 43 hours.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform