Time out issue on locating a product in the CP
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2915
Printed Date: 27-February-2025 at 11:30pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Time out issue on locating a product in the CP
Posted By: BYRSC
Subject: Time out issue on locating a product in the CP
Date Posted: 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?
|
Replies:
Posted By: Hamish
Date 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 - 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. ------------- Editing ProductCart Code? See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code |
Posted By: BYRSC
Date 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? |
Posted By: cognecy
Date 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 |
Posted By: ProductCart
Date 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 ( http://wiki.earlyimpact.com/productcart/managing_search_fields#mapping_custom_search_fields_to_export_fields - 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. ------------- The ProductCart Team Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software |
BYRSC wrote:Posted By: BYRSC
Date Posted: 03-August-2009 at 1:01pm
| That did the trick! Thank You!! |
Posted By: worldofrugs
Date 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) |