AbleCommerce Shopping Cart Software

I put this on hold for now. The execution path SQL Server creates seems a little screwy. The query runs fine if the inner most subquery returns more than 20 or so records, otherwise it takes many minutes. A stored procedure isn't any better (its already a parameterized query) and view doesn't work i...

Here are steps I took... 1. In ac database created full-text catalog and added full-text indexes to following tables:columns ac_Categories: Name, Summary ac_WebPages: Name, Summary ac_Links: Name, Summary ac_Products: Name, Summary, sku, searchKeywords, Description, ExtendedDescription 2. In Commerc...

I just modified the api source and using full-text catalog for search is amazingly fast for our large product catalog (400,000 products-120 categories). Results return nearly instantaneously. Searches before always timed-out (over 30 seconds), maxing out our production sql server's HDD. We're hostin...

We had to purchase api source to implement full-text catalog for search and some other performance modifications for our client's large product catalog. I was able to build CommerceBuilder.dll and the resulting release DLL is 1.48MB, but the original provided dll is 2.47MB. The application seems to ...

Change the default category display page to something other than the deep item display grid. Thanks for tip--will try. We like the deep categories since none of our 1st level categories contains products. Maybe there is another workaround since the results are unusual*: the applications category is...

I have downloaded your CSV and will let the import run tonight on a test install. Any luck? We are still having trouble. The Software > Application category with 250,000 products was timing out. We created 13 subcategories and moved products into each (14,000 to 26,000 products per category). Each ...

I have downloaded your CSV and will let the import run tonight on a test install. The problem with the Applications category (as you'll see) is that it contains 250,000 products so when you click to view a product's detail page, sql server has to return all 250,000 records to the web app so that it...

For a single user, which is only testing we did, moving from a dev box to a production system didn't make much difference (all the time-outs remained). Adding those 3 indexes I posted earlier fixed 80% of the bottlenecks on production and on dev systems. I was impressed that after those db changes A...

There are a couple of areas that need to be tuned for large catalogs. Thanks for the tip. I can understand that AC7 (like most ecom packages) is optimized for average size catalogs, which are smaller than 350,000 products. I was able to tune most problem areas, however execution time for some of th...

Thanks for all the suggestions. I agree faster hardware and a server OS would perform better. I was looking to test relative performance on my dev box for initial testing. The same 350,000 products in ZNode running on same hardware didn't cause any timeouts on Admin side (although slowest page took ...

Here is the products CSV file I used to import products. http://drop.io/ablecommerce (I had trouble with file upload)

Fred asked me to post this here. We are evaluating ecommerce packages. I imported 349,458 products with the DataPort tool into the AbleCommerce trial. It took 4 hours but completed successfully. No images. No extended description. Browsing the site caused several time out errors. We would have just ...