Web Wiz Forums - Search Time out

Print Page | Close Window

Search Time out

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19452
Printed Date: 12 April 2026 at 4:04am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Search Time out

Posted By: bruce
Subject: Search Time out
Date 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.

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bruce
Date 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.

Posted By: WebWiz-Bruce
Date 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

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bruce
Date 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.

Posted By: bruce
Date Posted: 24 April 2006 at 5:50pm

Is there any way to increase the time-out form 30 seconds to 60 seconds or more?

Posted By: WebWiz-Bruce
Date 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

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting