Largest AbleCommerce 7 store?

[nickc]

I'm interested in finding out how big an AbleCommerce 7 store can scale - from an application perspective, not hardware.
Does anyone out there have 100,000+ products and/or page views? I'd love to hear comments about and get links to your largest implementation of a store...

[igavemybest]

I have a ton of items, not over 100,000+, but able commerece should be unaffected by either this or page views. It is witten very well in ASP.NET (same as Myspace) and will be able to handle anything you can throw at it. The only limitations of it would be your SQL Server host and your AC7 host and their bandwidth.

[AbleMods]

There are plenty of performance boundaries that can be hit, both directly and indirectly related to a large catalog. How well the Able SQL scripts can respond with data totally depends on the hardware platform(s) involved and how well Able has designed the scripts.

I see a noticeable site performance hit when my page views table passes 150,000. My db and site are on the same machine running 15k drives with a dual-core Xeon and 4Gb RAM. No other sites or apps on the server. Then there are all the anonymous baskets, log files and IIS logging still to contend with in the background.

My simple search is already taking 3-5 seconds to respond and I'm only running 10,000 products, another 12,000 variants and roughly 66,000 product image files. I sure wouldn't want to see it with 100,000 products

[Shopping Cart Admin]

Hello Joe,

Besides not being PCI compliant running your SQL server on the same box is a big performance issue. On equipment much less than you're running on our older 5.5 product I've seen sites doing nearly 300gb of traffic a month. SQL server MUST be on it's own server to have any clue as to the performance capability of AbleCommerce 7.0!

The search must be optimized for large catalogs that's for sure, but all of the rest of the queries have been tested with over a million products.

[nickc]

I've seen mention of implementing FTS, that it was originally left off for portability to MySQL which never transpired. Is this in the works?