Upgrade from 7.2 to 7.7 Slow site

[trozzi]

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

[Katie]

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?).

[jmestep]

If you installed build 14481, there is a section of code that looks at the page views table to get a category id.

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];
            }

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 .