Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

X-Cart Scalability with many "Product Variants".
 
Reply
   X-Cart forums > Considering X-Cart > Considering using X-Cart for my project
 
Thread Tools Search this Thread
  #1  
Old 03-21-2011, 06:10 PM
 
mbhaney mbhaney is offline
 

Newbie
  
Join Date: Mar 2011
Posts: 5
 

Default X-Cart Scalability with many "Product Variants".

Will this platform scale?

Context: I'm adding products to my new (and first experience) instance of XCart Pro 4.4.2 and I see the documentation recommends against using too many "Product Variants". How many is too many?

So I'm concerned as to how big of an issue this may become.
I have between 4 & 5 thousand products, each needing two levels of Variant, mainly to specify quantity in stock, SKU, & weight separately.

E.g. Product #1 is available in 60 colors and each of those 60 colors is available in 9 sizes. (Total of 540 SKU's to track quantity on hand & price, just for one base product.) Then product #2 has 33 colors and 6 sizes (198 SKUs.)

Most of the products will only have 15 to 20 colors and 5 or 6 sizes. But still, this extrapolates to a huge number of SKUs.

Am I pushing X-Cart beyond it's capability by trying to do this?
More specifically, what level of hardware platform should I be looking at to make sure my online shoppers get a reasonable response while browsing products at my store? (I'm hosting my own, and control my hardware/software stack)

I'm not asking about disk capacity & internet bandwith as I can calc that. I'm concernd with CPU class & speed requirements, and then DB (MySQL) performance.

Any insight in this area is highly appreciated. Thanks in advance!
__________________
X-Cart Pro 4.4.2
No add-ons (yet)
Reply With Quote
  #2  
Old 03-22-2011, 05:08 AM
  ambal's Avatar 
ambal ambal is offline
 

X-Cart team
  
Join Date: Sep 2002
Posts: 4,102
 

Default Re: X-Cart Scalability with many "Product Variants".

"Too many" mean having ~10+ product variants for the same product.

In your case 2 variants (color & size) should be fine.

However, taking in account qty of products are going to have and variants you will need a dedicated server. However, I am not sure about CPU, RAM and other params. I hope someone from X-Cart hosting providers will tell something here.
__________________
Sincerely yours,
Alex Mulin
VP of business development for X-Cart
X-Payments project manager
Reply With Quote

The following user thanks ambal for this useful post:
mbhaney (03-22-2011)
  #3  
Old 03-22-2011, 05:31 AM
 
mbhaney mbhaney is offline
 

Newbie
  
Join Date: Mar 2011
Posts: 5
 

Default Re: X-Cart Scalability with many "Product Variants".

Thanks Alex. That is very reassuring!

I'm now looking into the procedure to migrate this XCart instance to a dedicated box with more horsepower.

I'll move it to a 64 bit dual core machine to open the store. If the enterprise gets enough activity to slow that machine down, that means there is enough revenue to subsidize a more substantial hardware stack. And I'll upgrade from there.
__________________
X-Cart Pro 4.4.2
No add-ons (yet)
Reply With Quote
  #4  
Old 03-22-2011, 05:59 AM
  twl's Avatar 
twl twl is offline
 

X-Cart team
  
Join Date: Jul 2009
Posts: 17
 

Default Re: X-Cart Scalability with many "Product Variants".

Strong dedicate server is required. Or good semi-dedicate

We're using the following hardware configuration for semi-dedicated servers, two Intel Xeon-Westmere 5670-Hexcore [2.93GHz] CPUs with 12 Gb of RAM. It's expensive but effective. We're using LiteSpeed and Nginx+Apache webservers, with PHP caching it improves the performance.

And finaly, it's recommended to conduct the optimization procedure for your store. Generate HTML Catalog, check the code and webserver+php+mysql configuration.
__________________
Sincerely yours,
Victor Driantsov,
Head of Qualiteam Hosting Department
http://www.x-cart.com/hosting.html
http://www.x-shops.com/
Reply With Quote

The following user thanks twl for this useful post:
mbhaney (03-22-2011)
Reply
   X-Cart forums > Considering X-Cart > Considering using X-Cart for my project


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 05:13 AM.

   

 
X-Cart forums © 2001-2018