Customizing ProductCart - A million products

Print Page | Close Window

A million products

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=3698
Printed Date: 05-May-2024 at 1:32am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: A million products

Posted By: amscompanies
Subject: A million products
Date Posted: 11-May-2010 at 7:58am

I'm looking at setting up a ProductCart store, but my fear is how will it handle 1 million unique products. I have a seperate database used for driving a football/soccer stats site, that will also be used to populate the products table

Does anyone think I'm going to have issues or suggestions on what I may need to do to the script to enable it to work ?

Replies:

Posted By: Greg Dinger
Date Posted: 11-May-2010 at 10:40am

I have one client who has 600,000 products. The search is a bit slow and we just altered it to limit the scope, but other than that they are running successfully.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: amscompanies
Date Posted: 11-May-2010 at 10:53am

I plan to include 3 search fields, do you think that will optomise the search enough to make it run efficently enough ?

Thus not using the product cart search at all

Posted By: Greg Dinger
Date Posted: 11-May-2010 at 10:58am

Sorry, I don't feel I can predict that for you. Just be sure to get a very robust server with MSSQL on a separate server and give it a shot.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |