Problem: The viart db expands greatly due to due to the two tables va_tracking_pages and va_tracking_visits.
These are used to logging visits to the site.
----------
The SQL query to remove data from these tables is:
delete from va_tracking_pages where date_added > 'yyyy-mm-dd' and date_added < 'yyyy-mm-dd'
delete from va_tracking_visits where date_added > 'yyyy-mm-dd' and date_added < 'yyyy-mm-dd'
----------------
How about putting this as an option (delete Tracking data) under System > DB management. Give size of database as well as the sizes of these two tables.
Then enter two dates, then its done.
No need to be an sql expert!!
----------------
SajMalik
2 Sep 2009 11:36 AM
One of the reasons I don't use Viart tracking is the growing DB and no simple way to remove old data.
