Zero-ing Statistics

Posted By kalkhovm Fri 24 May 2013
Add to Favorites0
Author Message
Neil Marked As Answer
 Posted Fri 24 May 2013
Supreme Being

Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)Supreme Being - (126,869 reputation)

Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192, Visits: 5,220
I use this sql to clear stats periodically (to keep the db size down)

EXEC [dbname].[dbo].[_spKartrisDB_DisableAllTriggers]
DELETE FROM [dbname].[dbo].[tblKartrisStatistics]
WHERE ST_ID > 8445782
GO
EXEC [dbname].[dbo].[_spKartrisDB_EnableAllTriggers]


You don't need to worry about triggers in V2 as these were removed. The ST_ID is the lowest you want to remove to.
kalkhovm
 Posted Fri 24 May 2013
Supreme Being

Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)Supreme Being - (9,766 reputation)

Group: Forum Members
Last Active: Mon 15 Jul 2013
Posts: 14, Visits: 153
Can you tell me the best way to Zero out the statistics, as currently the only way I can see to do this from within Kartris is to clear all product data and I really don't want to do that! Thanks

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top