|

Database Size, Archiving Old Orders
Posted 03 May 2014 - 10:29 PM #1
Many thanks for any help on this.
Kind regards,
Tony
Posted 04 May 2014 - 06:56 AM #2
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.
Posted 04 May 2014 - 10:22 AM #3
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
Elkhorn Graphics LLC
Cs-Cart 4.7.1 SP3
Posted 04 May 2014 - 07:19 PM #5
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.
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?
Posted 04 May 2014 - 08:13 PM #7
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.
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
Posted 04 May 2014 - 08:25 PM #9
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.
Posted 04 May 2014 - 08:32 PM #10
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
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.