Search Server Timouts
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=13511
Printed Date: 13 April 2026 at 12:02pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Search Server Timouts
Posted By: bjobra
Subject: Search Server Timouts
Date Posted: 26 January 2005 at 4:32am
|
FIrst, a wonderful application, i have paid my little share, and it has been a running wheel for a year with no problems, serving thousands of pain patients, until yesterday when this message started to appear
Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired /forum/search.asp, line 356 i have found a thread which ended up in nothing so i do not know if there is a solution. My server host has no problems with time out errors for other applications, my database is 60MB, and my dear patients have made 25000 posts.
I have increased the server.script timeouts to 180 in common.asp
I have no clue how to solve this. If i search only in subject line, it still works fine
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 26 January 2005 at 6:11am
|
You can increase the timeout for the SQL Server connection in the
'admin/SQL_server_connection.asp' file, by adding the following to in
red the end of the connection string:- strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";Connection Timeout=90;" If it still timesout, increase the 90 part by more. ------------- 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: dj air
Date Posted: 26 January 2005 at 6:12am
|
when searching the subject line its quicker than searching a whole post. this is why it works for one and not the other. does it take 3 minutes and then timout or is it sooner than that. because if its sooner than that it looks like your host has set a max timeout limit that can't be gone past. |
Posted By: bjobra
Date Posted: 26 January 2005 at 11:48am
| It takes around 10 sec. they have increased the timouts on the server, but now i consider to host my applications on an own server. |
Posted By: bjobra
Date Posted: 26 January 2005 at 11:56am
| So I have added the time. and increased it even to 360, but as this message appears after 30 seconds or so i beleive it is the host time out settings that are to short. I think though it is a little odd that a database of 60 MB and 25000 posts can cause this problem, as i can read of your application running on widely larger databases. |
Posted By: WebWiz-Bruce
Date Posted: 26 January 2005 at 2:15pm
|
The MS SQL Database for this site is currently running at 80Mb. One thing that may speed things up is to make sure that the recovery model of the MS SQL Server database is set to simple and log files are set to as low as possible. This would speed up the process time and keep your database size down to a minimum. ------------- 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: bjobra
Date Posted: 26 January 2005 at 2:45pm
| I can see that other users have had the same problem and has not got any solution for them. We have screwed up the host server timeouts now. No result. I will follow your advices above. Our log files are 6 MB, not huge. |
Posted By: bjobra
Date Posted: 31 January 2005 at 1:24pm
| So, it seems you/we have an awsome problem here. If the database expands the search function fails. I have made everything proposes with the same ugly search result as above. No one can search in texts in the forum, only if they choose to scan a single topic. One can search in headers. I am very disappointed. |
Posted By: dj air
Date Posted: 31 January 2005 at 1:32pm
|
please note that this is not due to the forum coding. this is due to your server setup. as you can search this forum or a number of forums and they are working fine. |
Posted By: bjobra
Date Posted: 31 January 2005 at 1:49pm
| If you give me a reference on a huge database where i can test, i will be very thankful. |
Posted By: dj air
Date Posted: 31 January 2005 at 2:15pm
| as -boRg- has said this one is 80 megabyte and ive just checked had 69 000 + posts.. try searching this forum.. |
Posted By: dudboy
Date Posted: 13 July 2005 at 12:06pm
Here is my setting
strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";Connection Timeout=360;"
And the search still falls over.
This is a dedicated server so I can change what I want, so is there anything that will fix the search functionality.
For the record the databe is 452.69mb and the transactional log is 13.78,b http://www.clubgti.com/forum - www.clubgti.com/forum------------- www.clubgti.com www.clubgti.com/forum |
dj air wrote:Posted By: dudboy
Date Posted: 13 July 2005 at 12:21pm
|
For reference my settings are
Website connection timeout = 900 (IIS) SQL server timeout = 0 (Unlimited) (SQL) SQL Connection string = 900 And I still get the same errors.------------- www.clubgti.com www.clubgti.com/forum |