I deleted partial data and now I have a problem

[kal130]

Hello All,

I recently cleared out the relevant db tables because i wanted to re input all my products. I failed to remove all the entries in the zen_meta_tags_products_description table and now i have over 10,000 entries in there. Sometimes it takes a long time for my site to load, unless i refresh the page.

I have 2 question:

1. is it safe to delete all the entries up to the point where the new products start.
2. Do you believe that this may be the reason why my site is sometimes slow? ( i have about 300 products that have different attributes, and ive read that also slows the site down), but hopefully that meta_tags table has something to do with it as well...

[spheric]

1. yeah. i'd do it to a test copy of your present database. you might have to reindex the table.

2. probably not. SQL would have throw an error is it thought it couldn't find the right record for the query.

[DrByte]

I recently cleared out the relevant db tables because i wanted to re input all my products. I failed to remove all the entries in the zen_meta_tags_products_description table and now i have over 10,000 entries in there.

1. is it safe to delete all the entries up to the point where the new products start.

If you're going to do mass deletes of data, you NEED to be sure to delete ALL related data. Leaving fragments behind can cause all manner of odd problems. While metatags are unlikely to be contributing to slowness problems, if you don't delete the orphaned records then you run the risk of having metatags assigned to wrong products. Always keep data in sync. Period.

If you've actually deleted all the records in your products tables, then you need to delete ALL the records in your products-metatags table. Not just the records over a certain number.

Selective data manipulation is dangerous. Be sure you study all the relationships between tables before manually deleting data.