Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Productview table purge

  1. 10-28-2009, 09:05 AM #1
    roberth is offline Junior Member
    Join Date
    Oct 2009
    Posts
    3

    Default Productview table purge

    Is it harmful to purge the productview table and only keep 5 days? Currently the table only has 30 days worth of data and its at over 2 million records. Its effecting SQL servers performance.
  2. 10-28-2009, 09:46 AM #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    It's not going to hurt anything, it'll just skew the results a little since you won't have as big of a sample.
    ECommerce Shopping Cart