Hello,
We are testing an upgrade from 7.2 to 7.7 and have noticed that after a few page clicks the site slows down considerably. We have isolated the issue to the fact that the ac_pageviews table has close to 4 million rows. We also found a post that indicated that additional indexes may be required on table ac_pageviews. Ran SQL profiler and tuning advisor and no recommendations were indicated.
7.2 handles the table fine. Is there a fix for this behavior?
Thanks
Thomas
Upgrade from 7.2 to 7.7 Slow site
Re: Upgrade from 7.2 to 7.7 Slow site
Prior to version 7.0.7, AbleCommerce had some issues with maintenance cleanup. We had released a patch for older versions, but maybe it was never applied to your 7.0.2 install.
In any case, here is a document that will help -
http://help.ablecommerce.com/upgrades/a ... enance.htm
I would read through the whole thing and then determine where cleanup needs to happen. Obviously, the ac_pageviews table needs to be purged. After upgrading, the application is probably trying to run maintenance on that table (and others?).
In any case, here is a document that will help -
http://help.ablecommerce.com/upgrades/a ... enance.htm
I would read through the whole thing and then determine where cleanup needs to happen. Obviously, the ac_pageviews table needs to be purged. After upgrading, the application is probably trying to run maintenance on that table (and others?).
Thank you for choosing AbleCommerce!
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Upgrade from 7.2 to 7.7 Slow site
If you installed build 14481, there is a section of code that looks at the page views table to get a category id.
That caused performance problems like what you are experiencing and Able changed it in Build 14600. The code is in the App_Code/PageHelper.cs .
Code: Select all
if (product.Categories.Count > 0)
{
PageViewCollection categoryPageViews = PageViewDataSource.LoadForCatalogNodeType(CatalogNodeType.Category, Token.Instance.User.UserId, "ActivityDate DESC");
foreach (PageView categoryPageView in categoryPageViews)
{
if (product.Categories.Contains(categoryPageView.CatalogNodeId))
return categoryPageView.CatalogNodeId;
}
//RETURN THE FIRST CATEGORY ASSOCIATED WITH THIS OBJECT
return product.Categories[0];
}
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx