Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to optimize massive DELETE operation
Message
 
 
To
26/08/2011 12:45:27
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01521854
Message ID:
01521919
Views:
39
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform