Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / General Questions / Limitations of Zen-Cart? (linked products, unique products)

Limitations of Zen-Cart? (linked products, unique products)

Locked

Started by nisdats on 23 Jul 2009, 5:48 AM · Views: 2,161

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
23 Jul 2009, 5:48 AM
#1
nisdats avatar

nisdats

New Zenner

Join Date:
Apr 2009
Location:
Houston
Posts:
41
Plugin Contributions:
0

Limitations of Zen-Cart? (linked products, unique products)

Dear Zen-Cart Team,

What are the limitations of Zen-Cart + MySQL ?

More specificly, our auto parts store will have 500,000 (half a million) records in the products_to_categories table. We will have over 20,000 unique products, cross linked to an AVERAGE of 25 or more categories.

Our Make-->Model-->Year selection is currently done through zen-cart categories.

Is this huge number of unique products plus large scale cross-linking sustainable with MySQL + Zen-Cart ? Can we handle a 500,000+ product_to_category table ?

Thank You for any help in this matter.

-Igor

23 Jul 2009, 1:42 PM
#2
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: Limitations of Zen-Cart? (linked products, unique products)

As far as I know, Zen Cart is only limited by the capacity of your server to store the information in the database.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

23 Jul 2009, 7:58 PM
#3
nisdats avatar

nisdats

New Zenner

Join Date:
Apr 2009
Location:
Houston
Posts:
41
Plugin Contributions:
0

Re: Limitations of Zen-Cart? (linked products, unique products)

I think you're right in theory, however, in practice... ?

this thread has me very worried: http://www.zen-cart.com/forum/showthread.php?t=83340

Does anybody know if zen-cart can keep up with my huge number of categories?

25 Jul 2009, 11:06 PM
#4
d1rage5 avatar

d1rage5

Zen Follower

Join Date:
Jan 2008
Location:
Roswell, Ga USA
Posts:
144
Plugin Contributions:
0

Re: Limitations of Zen-Cart? (linked products, unique products)

I would have to say looking back at the post from a long while back that this would be a host provider. I know for a fact that i have 10000 products and a lot of cross links items.

I have to change providers because my old one could not handle the load between mysql Db and the site. My new host that i have been with for a year now i have had no issues and they are on the list of providers that support large db quaries.

So i would think you should not have an issues besides times linking items... thats with any cart