2. ASPRunnerPro General questions
  3. timeout expired
This topic is locked

timeout expired

 		3/7/2007 9:28:31 PM
ASPRunnerPro General questions
J
 Joseph Zuanger author

Hi,
I have a database containing about 15 milliom records in one table.

Almost every time when i do a search, timeout expired error message occurred. Any suggestions on how to minimize this problem if it can not be avoied?

thanks!

JOe
Sergey Kornilov admin 3/7/2007

Joseph,
you need to reorganize your data, add indexes etc to make sure most common searches run fast.
You can also increase script timeout however it only fixes consequences without resolving the problem.
E
 		evileyez3 8/17/2007

Joseph,

you need to reorganize your data, add indexes etc to make sure most common searches run fast.
You can also increase script timeout however it only fixes consequences without resolving the problem.


Admin,
I'm having this problem as well. However, it's happening after I click one of my options from the menu. The tables contain millions of records. I'll see what the DB admin can do about the database, but where is this script located to increase the timeout limit? I thought it was under richtext.js as this was the only place I could find "timeout". However increasing the value made no difference. Please help. Thanks.
Sergey Kornilov admin 8/17/2007

Add the following command in the beginning of the file that times out

<%

Server.ScriptTimeout = 3600

%>