Upgrade 7.0.2 to 7.0.7

[trozzi]

Hello,

We are upgrading a 7.0.2 site to 7.0.7 and we are experiencing long page loads in 7.0.7.

The db scripts were run from 7.0.3 to 7.0.7 with no errors.
Updated code files and dlls as appropriate.

Ran a test dry run on a dev site and the pages load as expected after initial compile.

When we try to move to production, the site slows down dramatically.

Any suggestions.

Thanks
Thomas

[Katie]

Hi Thomas,

This could happen from a build up of records in the database. In earlier versions, the maintenance routines didn't automatically remove records (default setting was set to leave them in). Here is a document that explains what you can do -

http://help.ablecommerce.com/index.htm# ... enance.htm

It might be the problem, but if not, please post back.

Thanks
Katie

[trozzi]

Hello Katie,

Very strange thing happened.

We set up a development site with 7.0.7 and upgraded the database. Upgrade went well and development site was responding very well. We then ported the production site to the 7.0.7 files and updated the key to production. Once we did that, the site slowed down to a crawl???

Any suggestions?

Thanks
Thomas

[Katie]

A production site would likely have a build up of anonymous user records, activity logging, etc. Did you look at the link I posted? If you are sure that the maintenance issues are taken care of, then go to this page -

viewtopic.php?f=42&t=17625&p=75890&hili ... ard#p75890

I try the tuning wizard. This can help with performance if the database is really large.

[trozzi]

Hi Katie,

I did read the post you suggested. The Able Error log has several entries that imply a timeout. "Request timed out."

I receive no message on the screen as such.

Thanks
Thomas

[Katie]

Please try tuning the database using the last link I posted. Then, if you continue seeing timeout errors, post the full error message here so we can see what is having trouble.

Thanks
Katie

[jmestep]

Able 707 build 14481 had code that looked at the page views table to determine what category to send a person to when they clicked on a product. It was in App_Code/PageHelper.cs public static int GetCategoryId(bool checkReferrer)
That slowed pages down tremendously so make sure you do not have that code on the site. B 14600 fixed it.