Database Getting Huge - What To Do?

General Forums General Questions
#1

Hi Guys, I've noticed my database is getting up to 500mb in size. The largest table is; cscart_order_data at 196mb - can this be cleaned or reduced in size? i suspect its holding every order we've ever received.



Thanks,



Scott.

#2

[quote name='Scott_C' timestamp='1401084933' post='184241']

Hi Guys, I've noticed my database is getting up to 500mb in size. The largest table is; cscart_order_data at 196mb - can this be cleaned or reduced in size? i suspect its holding every order we've ever received.



Thanks,



Scott.

[/quote]



This table contains the following data about your orders


  • secondary currency
  • coupons
  • payment information
  • taxes information
  • shipping information
  • product groups information
  • addons information



    If you clean it, almost all information about your orders will be lost.
#3

Archiving old orders might be a way to go.

#4

[quote name='cscartrocks' timestamp='1401105904' post='184280']

Archiving old orders might be a way to go.

[/quote]

Is there a setting in CS to do this or is this done in phpmyadmin?

#5

[quote name='clips' timestamp='1401111066' post='184289']

Is there a setting in CS to do this or is this done in phpmyadmin?

[/quote]



No, there is no such a setting.


[quote name='cscartrocks' timestamp='1401105904' post='184280']

Archiving old orders might be a way to go.

[/quote]



What do you mean by “Archiving old orders” ?

#6

[quote name=‘eComLabs’ timestamp=‘1401111443’ post=‘184290’]

No, there is no such a setting.







What do you mean by “Archiving old orders” ?

[/quote]



I would think an SQL script that empties the table within a certain date range.

[quote name=‘cscartrocks’ timestamp=‘1401105904’ post=‘184280’]

Archiving old orders might be a way to go.

[/quote]



Thanks Louis, I’ll be in touch. :-)

#7

I would examine what's in the order_data table. Note that this is kind of a dumping ground for storing data related to an order but that is generally not searchable. I.e. if you have some custom mods or your sell products that have the user upload imagery or other files, then that's where that data would be stored.



Suggest you review the data to see if it's appropriate for your site.

#8

Thanks guys for all the help. Im getting an SQL query written to backup the order data and then empty it from the db (leaving the last 12 months intact) With the backup functionality, it can be restored at any time.