What is the best way to delete records omitted from a data feed?

Tags:
Database
Database administration
SKU
I have a very dynamic vendor who adds and deletes products daily. They provide major updates twice daily and while they don't provide inventory numbers - just "in stock" and "out of stock" every 15 minutes. Obviously, it is not feasible to update my db every 15 minutes. However, my question is, would I be better off to build a temporary single column file which contains all sku's provided from the data feed and then parse my products table and 200+ categories deleting the table after updating all applicable tables or date stamp the product table and delete any record that was not included in that days major update feed. I am leaning toward the temp file as it would reduce the overhead of the date stamp.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: