AbleCommerce Shopping Cart Software

Hi there,

I initially setup my ecommerce site with 10k products, everything seemed ok. but the products are not 550k, and everything times out. I want to know how much Ablecommerce can handle. Is there a way to fix this problem?

thanks

Hello,

Please give us some more information on the issue, I don't really understand what's happening.

hi,

as soon as I imported about 550k products into the AbleCommerce catalog, everything became pretty slow. in most cases, connections timeout. Searches usually timeout. What I want know if AbleCommerce can handle that many products. Is database optomized to handle this? By the way, this is on a dedicated server.

Hello,

The database is optimized for large record sets. However with large databases certain types of display templates, that have paging and such can have issues with such a large data set. You'd certainly need full text search enabled and a fast database server, not running on the web server box.

Also for large record sets after the database is populated run the sql tuning tool and make any changes it suggests for your data.

Mike,

All of a sudden I'm getting this when trying to click on a product to get to the product detail page. do you have any idea?

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 46: //PREPARE BASKET FOR DISPLAY
Line 47: Basket basket = Token.Instance.User.Basket;
Line 48: basket.Package(true);
Line 49: basket.Recalculate();
Line 50: //VALIDATE THE BASKET


Source File: c:\webSites\CaliforniaSales\ConLib\MiniBasket.ascx.cs Line: 48

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
CommerceBuilder.Orders.BasketItem.CanCombine(BasketItem other) +269
CommerceBuilder.Common.SortableCollection`1.Find(Predicate`1 match) +80
CommerceBuilder.Orders.BasketItemCollection.Combine(Boolean save) +795
CommerceBuilder.Orders.Basket.Package(Boolean resetGiftOptions, Boolean doCombine) +667
CommerceBuilder.Orders.Basket.Package(Boolean resetGiftOptions) +13
ConLib_MiniBasket.Page_PreRender(Object sender, EventArgs e) in c:\webSites\CaliforniaSales\ConLib\MiniBasket.ascx.cs:48
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnPreRender(EventArgs e) +8682870
System.Web.UI.Control.PreRenderRecursiveInternal() +80
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.WebControls.WebParts.WebPart.PreRenderRecursiveInternal() +42
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint