Disable Maintenance Routines

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
kittruong
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 37
Joined: Tue Feb 22, 2005 2:31 pm

Disable Maintenance Routines

Post by kittruong » Tue Apr 28, 2020 1:28 pm

I know there's been several threads about this but I couldn't find one that works.

What's happening is that I'm getting errors due to long waits on my SQL Server whenever AbleCommerce wants to perform a maintenance routine like delete anonymous users, baskets, etc and it's causing my SQL Server to boggle down.

All I want to do is disable all the AbleCommerce maintenance routines as I don't need them since I'm already manually cleaning up my tables directly on the SQL Server once a week.

This is the version I'm running:
AbleCommerce for ASP.NET
VERSION: 7.0.86.6169
Release Label: GoldR6
DATABASE: NHibernate.Dialect.MsSql2005Dialect

Thanks

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Disable Maintenance Routines

Post by AbleMods » Thu May 14, 2020 5:52 am

A late reply but hopefully will still help.

Maintenance can be disabled by editing the /App_Data/AbleCommerce.config file and setting the MaintenanceInterval value to "0".

However this is a really, really bad idea. Several other important functions are performed in the maintenance routines unrelated to user maintenance. You are all but guaranteed to create more problems than you solve by disabling maintenance.

Gold R6 is an extremely old release of Able Gold. The maintenance routines were substantially improved in later releases. You should update to at least R11 or ideally R12. Maintenance routines are improved and a bazillion bugs and issues are resolved by the time you get from R6 to R12.

If updating to R12 does not fully resolve your maintenance lag, start evaluating the performance of your SQL box. I've seen poorly configured SQL boxes lag a store so bad maintenance can't even run at all. 11,000,000 users records later, the store itself bogs down badly.

Finally, CloudFlare can help a great deal. The vast majority of anonymous users are created as a result of bots crawling the site. A few simple rules in CloudFlare can keep most of those bots out. This can have tremendous impact on reducing the number of new anonymous users each day which in turn reduces the workload required for maintenance to complete.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply