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