Hello, I'm searching examples of stores with many products.

The best would be around 200k products.

I remember that Linda was working on a 700k products store in 2006 but I've never seen the site and I remember she was modifying the code since the standard code had poor performance.

I'd like to know if someone is running a non modified Zen Cart (1.3.8) with 200k products or more (well also the situation of attributes is important of course).

Last: which hardware would you suggest for a dedicated machine? Unfortunately the os must be win2003 server. I'd prefer linux but I already worked with this os and apache (on another dedicated machine) and had no particular problems with Zen Cart.

About webserver, php and mysql I thought:

Apache: 2.x
PHP: 5.2.x
MySql: ? Better to go with 5.x?

I don't know when (and even if) this project will start. Unfortunately it will require many modifications, so I believe we'll loose the possibility to smoothly upgrade to 1.4 if we start with 1.3.8. So: is it sure that 1.4 will be released by the end of the year? If so, maybe we could posticipate the starting date of the project.

Thanks.