Web Wiz Support and Community Forums : Search Time out https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 02:23:27 +0000 Tue, 25 Apr 2006 09:09:43 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19452 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Search Time out : To increase the timeout in the...]]> https://forums.webwiz.net/search-time-out_topic19452_post105462.html#105462 Author: WebWiz-Bruce
Subject: 19452
Posted: 25 April 2006 at 9:09am

To increase the timeout in the connection string change line 186 of the file database_connection.asp to the following:-

strCon = "Provider=SQLOLEDB;Connection Timeout=360;" & strCon
]]> Tue, 25 Apr 2006 09:09:43 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105462.html#105462 <![CDATA[Search Time out : Is there any way to increase the...]]> https://forums.webwiz.net/search-time-out_topic19452_post105431.html#105431 Author: bruce
Subject: 19452
Posted: 24 April 2006 at 5:50pm

Is there any way to increase the time-out form 30 seconds to 60 seconds or more?]]> Mon, 24 Apr 2006 17:50:34 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105431.html#105431 <![CDATA[Search Time out : I&#039;m on a semi dedicated server...]]> https://forums.webwiz.net/search-time-out_topic19452_post105429.html#105429 Author: bruce
Subject: 19452
Posted: 24 April 2006 at 5:34pm

I'm on a semi dedicated server with Jodohost and the SQL db is on the same server, so server load should not be an issue.

Sounds like your doing some tweaking, let me know if you have any suggestions.

]]> Mon, 24 Apr 2006 17:34:00 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105429.html#105429 <![CDATA[Search Time out : It still shouldn&#039;t be...]]> https://forums.webwiz.net/search-time-out_topic19452_post105427.html#105427 Author: WebWiz-Bruce
Subject: 19452
Posted: 24 April 2006 at 5:28pm

It still shouldn't be that slow with that many posts, unless the SQL server is under allot of load.

I've been doing tests on a similar size database and by searching ALL posts I was getting the results in under 20 seconds with a max of 500 results returned and 9 seconds with 100 results returned.

I have been playing with the SQL though and got this down to around 1 second with 500 results returned, by changing the ORDER BY clause to go by Thread_ID instead of Message_Date in the SQL


Edited by -boRg- - 24 April 2006 at 5:30pm]]> Mon, 24 Apr 2006 17:28:31 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105427.html#105427 <![CDATA[Search Time out : If the search critirea takes more...]]> https://forums.webwiz.net/search-time-out_topic19452_post105420.html#105420 Author: bruce
Subject: 19452
Posted: 24 April 2006 at 5:12pm

If the search critirea takes more than 30 seconds then it times out.
 
I have ~ Our users have posted 234,163 Posts in 17,597 Topics in 18 Forum(s)
 
I have to set intMaxResults to 10 or it times out most of the time, unless the criteria is really narrowed down.
]]> Mon, 24 Apr 2006 17:12:48 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105420.html#105420 <![CDATA[Search Time out : If this continues to be an issue,...]]> https://forums.webwiz.net/search-time-out_topic19452_post105131.html#105131 Author: WebWiz-Bruce
Subject: 19452
Posted: 21 April 2006 at 10:14am

If this continues to be an issue, one thing you could do is limit the number of results returned in the search to say 100 by editing the file 'search_process.asp'

Change the part in red below to 100, or less if need be, of the file 'search_process.asp':-

intMaxResults = 500

By limiting the number of results to 100 you will get 10 pages of search results instead of 500 which should be enough search results for anyone to sift through.

By setting it to 100 it will also speed up large searches by 5 times.
]]> Fri, 21 Apr 2006 10:14:00 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105131.html#105131 <![CDATA[Search Time out : An index on the database in this...]]> https://forums.webwiz.net/search-time-out_topic19452_post105129.html#105129 Author: WebWiz-Bruce
Subject: 19452
Posted: 21 April 2006 at 10:06am

An index on the database in this instance would not help as indexs are already created.

The problem is with searches on 'Any Date' that search the entire post is that the post column in the database needs to be searched and as this is a large text datatype in can not be indexed anyway.

How many posts do you have in your forum for this to happen?

Searches shouldn't take that long to do, unless you have half a million posts to search through or the SQL Server is running slow.
]]> Fri, 21 Apr 2006 10:06:48 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105129.html#105129 <![CDATA[Search Time out : After upgrading to v8.1, I&#039;m...]]> https://forums.webwiz.net/search-time-out_topic19452_post105043.html#105043 Author: bruce
Subject: 19452
Posted: 20 April 2006 at 3:12pm

After upgrading to v8.1, I'm still getting time outs in the forum search.  I've brought up the issues with Jodohost and this was their reply.
 
Hello,

You can try to use "Connection Timeout=360" in your connection string.
This is certainely a DB issue and you need to create an index to help with "Any date" queries.

You can take help about this at WebWizforums.
 
So..  A couple questions.
 
Is their reply correct and if so how do I change the timeout in the connection string?  Will change the connection string resolve my problem?
 
Right now the search is timing out at 30 seconds which is not nearly enough time for the search to complete.
]]> Thu, 20 Apr 2006 15:12:05 +0000 https://forums.webwiz.net/search-time-out_topic19452_post105043.html#105043