Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to optimize massive DELETE operation
Message
 
 
À
26/08/2011 12:45:27
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
01521854
Message ID:
01521919
Vues:
40
>Hi,
>I importing every day massive recordset from different manufacturers with updated pricelist and artikel set. Before import it, I delete old one, and then INSERT BULK another pricelist.
>Don't exact understand what you mean about pk_id, but pk_id field exist, its guid string and updatable

My question is - in that table do you have 1 record per manufacturer or many records per manufacturer?

Also, did you try MERGE statement (assuming you're using SQL 2008) to update records instead of deleting and insert non-matched delete not-matched by target

?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform