Many X-cart sites that have been around a while start to get slower and slower. This is especially true if you have the Advanced Statistics module on. This module is required to be on for the bestsellers module to work. The good news is, there’s usually a really easy quick fix for speeding up your X-cart site! We have a free module that you can upload and either run manually or set it up as a cron (ask your host how to do this if you don’t know how). We’ve been using this free module for years for all of our hosted customers that need extra speed. Check out our FREE Clean Stats mod for X-cart!
The module simply cleans out the xcart_stats tables that you don’t need for bestsellers to work. Many people do not use the data in these because they have better analytics when using Google Analytics or something similar. For larger or order sites, these tables just keep getting bigger and bigger, eventually getting millions of rows of data in them. When a user browses the site, a new row is entered. In simple terms, if you have too many rows then this will slow down the site to insert a new row.
Some sites need more work to speed them up than this but many times this is all that is needed! Contact Us if you need more X-cart Speed help!