How negatively would this affect the database?

General Forums General Questions
#1

I have a rather strange question that a client of mine asked me and to which I have no anser at all:-(.



If this client were to delete his categories list about 12 times a year (after trying locally this also deletes all his products in one go) and he would then add everything again (categories and products) also about 12 times a year, how negatively would this affect the database?

#2

[quote name=‘Martin’]I have a rather strange question that a client of mine asked me and to which I have no anser at all:-(.



If this client were to delete his categories list about 12 times a year (after trying locally this also deletes all his products in one go) and he would then add everything again (categories and products) also about 12 times a year, how negatively would this affect the database?[/quote]

I don’t think this is going to effect the database at all, all you would be doing is deleting data from the database and adding it back in. Why would someone want to do this 12 X’s over and why?

#3

It will affect the invoices in the Admin Backend. If you delete a product, the invoices’ table links (for product options, price, etc) are broken.



David

#4

[QUOTE]It will affect the invoices in the Admin Backend. If you delete a product, the invoices’ table links (for product options, price, etc) are broken.[/QUOTE]



If it would break this it also means that this information is not really removed and still in the database in a messed up form wouldn’t it?



If this is correct it does affect the database negatively.

#5

Yes and no, some of the order invoice information is stored in the invoice MySQL tables. But some of the invoice data is pulled from other tables (products, products_options, etc).



So if you remove the products (and especially their options), older invoices in the Admin Backend will lose some of their order data.



David

#6

I assume that if you delete the orders you would clear those database tables as well?

#7

Sure, if you do not want to keep track of all your old orders in cs-cart.

#8

Me thinks that as of 2.0.15, the order data is no longer tied directly to the products, options, etc. So the order info will remain.



To test it, find an order with a product with options. Go into the product detail and change the options. Then go and look at the order again. it will be the same as it was before showing that it’s no longer tied to the live product data.