X-Cart forums

[BCSE]

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

[JWait]

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!

[BCSE]

Originally Posted by JWait

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!

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

[JWait]

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

[hooter]

Originally Posted by JWait

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

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

For your cron job commandline try this:

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

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

[BCSE]

Originally Posted by hooter

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

For your cron job commandline try this:

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

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

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

Carrie

[BCSE]

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

[BCSE]

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