|
Time out issue on locating a product in the CP |
Post Reply 
|
| Author | |
BYRSC 
Newbie 
Joined: 16-September-2008 Status: Offline Points: 0 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Time out issue on locating a product in the CPPosted: 03-August-2009 at 11:10am |
|
I am constantly getting "Active Server Pages error 'ASP 0113' Script timed out" when trying to locate products in the control panel. I noticed it after the last product import we did. We have over 60,000 products now in our store. Does ProductCart not support this many items? Has anyone else had this problem?
|
|
 |
|
|
Hamish
Admin Group 
Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
Quote Reply
Posted: 03-August-2009 at 11:36am |
|
Hi,
ProductCart can readily handle that number of products, although hopefully they are not all within the same category :-) Take a look at http://wiki.earlyimpact.com/developers/timeout-issues. Also, if you can limit the search to particular categories of course that would be more efficient & so less likely to time out. Are you with a good quality hosting company? It's not uncommon for the cheaper hosting companies to run very large numbers of sites on a server, leading to resource issues so that as soon as you try anything that calls for a reasonable amount of processing/resource, things can become flakey. You are also more likely, on a heavily loaded server, to be impacted by other problems in other sites/applications. If none of the above helps please raise a support ticket. |
|
|
|
|
BYRSC
Newbie
Joined: 16-September-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 03-August-2009 at 11:55am |
|
I will give this a try. The problem does not exist when doing the search, it occurs when trying to load the LocateProducts.asp page itself and other product search related pages in the control panel.
What is an approximate number of items ProductCart can handle? |
|
|
|
|
cognecy
Certified ProductCart Developers 
Joined: 18-March-2006 Location: United States Status: Offline Points: 8 |
Post Options
Thanks(0)
Quote Reply
Posted: 03-August-2009 at 11:58am |
|
Hamish,
I would like to chime in on this one for a moment. I have noticed the frequency this timeout error and others increase accross the board 10-fold since v3.51 was released. I have been trying for months to track it down but not having much luck. Obviously querying the entire DB on a larg store stands the risk of generating a timeout but I have seen the same thing on small stores and new stores. This is definitely not a blanket "hardware issue.
I have seen this on my own servers and with many customers that I do not host. When it is on my own servers I mitigate this to some degree by making sure all domains are in a dedicated application pool and my closely monitiring the resources each site uses and adjust accordingly. What I see ranges anywhere from search timeouts to session timeouts. I know there is a wiki article on the session timeouts but it is not exhaustive of all the potential causes.
|
|
|
Mark Shipp
Cognecy Solutions, LLC Hosting/Design/Customization/Database Migration www.cognecy.com www.cognecy.co.uk |
|
|
|
|
ProductCart
Admin Group
ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
Post Options
Thanks(0)
Quote Reply
Posted: 03-August-2009 at 12:35pm |
If you are using a large amount of products AND are using Custom Search Fields, turn-off the "Show on Search Page" property for any Custom Search Field that has a large number of values assigned to it. For example, if you are using a Custom Search Field to associate a "UPC code" with your products for use when you export to Google Base (see the documentation on using Custom Search Fields for exporting purposes), this will definitely cause a performance issue as the system will load all of them as available search filter values for the "UPC Code" search filter. Edited by earlyimp - 03-August-2009 at 1:02pm |
|
|
|
|
BYRSC
Newbie
Joined: 16-September-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 03-August-2009 at 1:01pm |
|
That did the trick! Thank You!!
|
|
|
|
|
worldofrugs
Senior Member 
Joined: 24-April-2008 Location: United States Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 04-August-2009 at 4:27pm |
|
I had the same issue in version 3.12a...
While being hosted on a shared windows host, I was not able to change the timeout for this. However.... I did find a trick around it: In the file: OpenDB.asp in /includes/ at line: 8, I added the following 3 lines under: set connTemp=server.createobject("adodb.connection") connTemp.ConnectionTimeout = 0 connTemp.CommandTimeout = 0 Server.ScriptTimeout = 300 Most likely not a nice piece of code, but for me (a non-expert coder) it worked ;o) |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options
BYRSC wrote: