Free X-cart Clean Stats Mod
 

I just created a new free mod that allows you to set up a cron to regularly clean out your X-cart stats tables:

http://www.bcsengineering.com/store/product.php?productid=348&MMCF_xfCleanStats2

Many of our clients have been using this for years. This allows you to keep your Advanced Statistics on for bestsellers module but keeps the stats tables trimmed down for better performance on the site.

Carrie

Re: Free X-cart Clean Stats Mod
 

I just cloned a link in skin/common_files/single/menu_box.tpl inside the "Tools" section to the clean_stats.php and it works great.

Thanks!

Re: Free X-cart Clean Stats Mod
 

Great! I made the mod so quickly I didn't want to clutter it with how to make links in the various versions of X-cart. :) I'll add it in if it's really needed but shouldn't be hard for those who already know how to install mods.

Hope it helps!

Carrie

Re: Free X-cart Clean Stats Mod
 

I'd set it up as a cron if I knew how.:oops:

Re: Free X-cart Clean Stats Mod
 

On most common retail hosting platforms something like this should work.

For your cron job commandline try this:

Code:

---

cd /home/useraccount/public_html/admin;php -q clean_stats.php

---

Of course substitute your own proper folder path in the above example.

Re: Free X-cart Clean Stats Mod
 

Yes we have it set up like this on our sites. Should work for most.

Carrie

Re: Free X-cart Clean Stats Mod
 

Many people don't realize how FAST this will make your site if you have Advanced Statistics on so that you can have Bestsellers. We put it on all of our hosting clients to speed up their site. Gets rid of the slow queries for Advanced Statistics while still allowing Bestsellers to work!

Nice, simple and quick!

Carrie

Re: Free X-cart Clean Stats Mod
 

For some statistics out there. I installed this for a customer last night and their site load time was cut in half!

:)

Love to see things so simple make a site a lot faster.

Carrie