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
Upgrade 7.0.2 to 7.0.7
Re: Upgrade 7.0.2 to 7.0.7
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
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
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
Re: Upgrade 7.0.2 to 7.0.7
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
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
Re: Upgrade 7.0.2 to 7.0.7
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.
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.
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
Re: Upgrade 7.0.2 to 7.0.7
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
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
Re: Upgrade 7.0.2 to 7.0.7
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
Thanks
Katie
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 7.0.2 to 7.0.7
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.
That slowed pages down tremendously so make sure you do not have that code on the site. B 14600 fixed it.
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