ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - A million products
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

A million products

 Post Reply Post Reply
Author
Message
amscompanies View Drop Down
Newbie
Newbie


Joined: 25-March-2010
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote amscompanies Quote  Post ReplyReply Direct Link To This Post Topic: A million products
    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 ?
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
amscompanies View Drop Down
Newbie
Newbie


Joined: 25-March-2010
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote amscompanies Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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. 
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.