Max number of products?

Submitted by ldh987 on Mon, 2007-05-21 22:23 in Price Tapestry

Hi David -
I'm wondering if there's a max number of products that the script can run efficiently. I've read that others have installed multiple copies on various subdomains to improve speed, and I'm wondering at what limit one would need to do that. Thanks!

Hi, There are no fixed

Submitted by support on Thu, 2007-05-24 12:19

Hi,

There are no fixed limits as it is really just down to what you server is able to handle. In general, most hosting accounts have no problem with a few hundred thousand products spread across merchants with 10-15,000 products each. You will however start to encounter performance issues as you go about 50,000 products per merchant, and probably around 500,000 products overall.

The multiple sub-domains option is a good way to create a virtual category hierarchy and also improve performance, but ultimately it would be a case of see what your server can handle and split your site up if you start to see performance issues. The following thread discusses MySQL configuration for larger Price Tapestry sites...

http://www.pricetapestry.com/node/732

Cheers,
David.

Hi, I use pricetap. with

Submitted by zeetv75 on Thu, 2007-06-14 13:37

Hi,

I use pricetap. with more than 2179000 products and some merchant has 70000 products.

i'm on my own server (bi xeon) and i allocated 1Gb on key_buffer_size (mysql).

Everything is ok, but :

- i've deleted the "MATCH name AGAINST " in products.php : because with more than 2milion articles, i had response time about 10 or 15 seconds ! this is for relevant products. So now i just print a random of 20 products for the same merchant, and differents little others modifications.
regards