Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

Scripts timing out

Hello,

Our client is seeing timing out of asp pages in the application.  This is intermittent.  The hosting company says that the script is updating a lot of tables (about 10) and that is why even if the update query is simple (such as updating last name) it is timing out.  We are on shared servers and they said going on to a dedicated server or a  virtual private server will not solve the problem.

Our business requirement is to update those many servers and that cannot be changed.  Does anyone have any suggestions or solution?

Thanks,
0
perlwhite
Asked:
perlwhite
  • 4
  • 3
1 Solution
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
you can adjust the ScriptTimeOut property of the server object and see if that helps:

<% Server.ScriptTimeout = 999   '-- value is in number of seconds %>
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
You may want to look at the business process too.  There are probably multiple ways to optimize whatever it is you are doing.

For one, I would start by making all my inserts a function of a stored procedure.  Then it is on the db server.  Especially if table 2 can't be updated until table 1 is.  

You can also use ajax to update the tables as well.

What is it that requires updating 10 tables at a time though?  That sounds like a bit much.

Which hosting service are you using?
0
 
perlwhiteAuthor Commented:
Big Monty,

Is there any global place when I can put this line of code, there are about 100 asp pages?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
if you have an include file that's common to each page and is near the top of the page, you can pop it in there.

You can also set it directly in IIS if you have full access to it.
0
 
perlwhiteAuthor Commented:
Big  Monty,

I put the timeout code in a include file.  And when I test the application, getting a record for first search is fine but when I go back and select another person to search it takes significantly large amount of time to search.  There is nothing getting updated, just selecting a record!

How do check where is the problem now?

The host company said log file will not show database problems.
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
does running the same query directly in the database take a long time as well?
0
 
perlwhiteAuthor Commented:
No it does not take a long time.  It is quick.
0
 
perlwhiteAuthor Commented:
I am getting this error- Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.96-log]Query execution was interrupted

After doing some research, it tells me that if we run 32 bit classic ASP application on 64 bit machine (Windows 7), it will fail.

http://www.a2zmenu.com/Blogs/Miscellaneous/Microsoft-OLE-DB-Provider-for-ODBC-Drivers-error-80004005.aspx

Is this something that our hosting company will have to do?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now