Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » Zero-ing Statistics

Zero-ing Statistics

Posted By kalkhovm Fri 24 May 2013
Add to Favorites0

Zero-ing Statistics

Topic View Topic View Topic Options Topic Options
Author Message
kalkhovm
Posted Fri 24 May 2013
Supreme Being

Supreme Being - (9,770 reputation)Supreme Being - (9,770 reputation)Supreme Being - (9,770 reputation)Supreme Being - (9,770 reputation)Supreme Being - (9,770 reputation)Supreme Being - (9,770 reputation)Supreme Being - (9,770 reputation)Supreme Being - (9,770 reputation)Supreme Being - (9,770 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
Post Information
Neil Marked As Answer
Posted Fri 24 May 2013
Supreme Being

Supreme Being - (126,883 reputation)Supreme Being - (126,883 reputation)Supreme Being - (126,883 reputation)Supreme Being - (126,883 reputation)Supreme Being - (126,883 reputation)Supreme Being - (126,883 reputation)Supreme Being - (126,883 reputation)Supreme Being - (126,883 reputation)Supreme Being - (126,883 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.
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.047. 9 queries. Compression Enabled.