Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Database Size, Archiving Old Orders Rate Topic   - - - - -

 
  • fwaTony
  • Advanced Member
  • Members
  • Join Date: 04-Jun 13
  • 61 posts

Posted 03 May 2014 - 10:29 PM #1

How does everyone deal with old orders? Our database on the server is becoming quite big due to the orders that have been placed, how do you all resolve this? do you just delete the old orders after xx months or somehow archive them?

Many thanks for any help on this.

Kind regards,
Tony

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11425 posts

Posted 04 May 2014 - 06:56 AM #2

Curious how many orders you have and what you feel you will gain from deleting some?

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • fwaTony
  • Advanced Member
  • Members
  • Join Date: 04-Jun 13
  • 61 posts

Posted 04 May 2014 - 10:22 AM #3

I have almost 3500 orders, I only ask as my server keeps dropping out and when I questioned it they mentioned it was due to the database size??
so I wondered how everyone else deals with this, if there was a way to archive or if it's just a case of more server power needed?

Kind regards,
Tony

 

Posted 04 May 2014 - 02:55 PM #4

Don't believe number of orders has anything to do with it.. We currently have over 40,000 orders sitting in our database with no issues. If your server is dropping there are other issues. Are you on a shared server plan ?

Elkhorn Graphics LLC
Cs-Cart 4.7.1  SP3


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11425 posts

Posted 04 May 2014 - 07:19 PM #5

I'm guessing you are running out of server resources. Sounds like your business has grown and it's time to take the training wheels off.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • fwaTony
  • Advanced Member
  • Members
  • Join Date: 04-Jun 13
  • 61 posts

Posted 04 May 2014 - 08:04 PM #6

Don't believe number of orders has anything to do with it.. We currently have over 40,000 orders sitting in our database with no issues. If your server is dropping there are other issues. Are you on a shared server plan ?


No we are on a Dedicated. 2.7GHz, 2mb Cache, 250GB SATA, 2GB DDR3

What server are you on CarStickersDecals?

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11425 posts

Posted 04 May 2014 - 08:13 PM #7

2GB memory is probably a little light, I would recommend 4G minimum. No need to short yourself when you're already paying for a dedicated server. I would suggest you work with your host to determine the appropriate configuration for your needs as well as to find a mysql guru who can help you tune mysql to both cs-cart and your server resources. With mysql, goal is to get as much in memory as possible/reasonable.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • fwaTony
  • Advanced Member
  • Members
  • Join Date: 04-Jun 13
  • 61 posts

Posted 04 May 2014 - 08:19 PM #8

2GB memory is probably a little light, I would recommend 4G minimum. No need to short yourself when you're already paying for a dedicated server. I would suggest you work with your host to determine the appropriate configuration for your needs as well as to find a mysql guru who can help you tune mysql to both cs-cart and your server resources. With mysql, goal is to get as much in memory as possible/reasonable.


I have been speaking to my host and have agreed to upgrade to:
4 x 3.3Ghz, 8MB Cache, 500GB SATA, 8GB DDR3

Hopefully this will solve the issues

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11425 posts

Posted 04 May 2014 - 08:25 PM #9

That's a lot of horsepower for someone with only 3500 orders of history.... You can always throw hardware at the problem, but you'll be better served following the recommendation above. I'm sure your host is more than happy to sell you a bigger system. But some tuning would reap you much greater rewards in the long run. All you need is more memory and some tuning.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • fwaTony
  • Advanced Member
  • Members
  • Join Date: 04-Jun 13
  • 61 posts

Posted 04 May 2014 - 08:32 PM #10

Thanks tbirnseth, I will look into this and find someone that will take a look, in the mean time at least it will solve my issue.
I think I needed to upgrade anyway as we are just about to launch another website on the same server so at least it will help across the board.

 

Posted 05 May 2014 - 02:15 AM #11

No we are on a Dedicated. 2.7GHz, 2mb Cache, 250GB SATA, 2GB DDR3

What server are you on CarStickersDecals?


We are running the Xeon 5520 8 x 2.00GHz+HT 16 GB Ram and dual 120 SSD's.. Ask about SSD's...
The SSD's made the most improvement all on there own.. They cut out SQL query times in half..

Elkhorn Graphics LLC
Cs-Cart 4.7.1  SP3


 
  • fwaTony
  • Advanced Member
  • Members
  • Join Date: 04-Jun 13
  • 61 posts

Posted 05 May 2014 - 09:39 AM #12

We are running the Xeon 5520 8 x 2.00GHz+HT 16 GB Ram and dual 120 SSD's.. Ask about SSD's...
The SSD's made the most improvement all on there own.. They cut out SQL query times in half..


That is the type of advice that I was looking for and I think a lot of other people will find this useful. Thanks.