Search Server Timouts

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
bjobra Members Profile Find Members Posts Newbie Joined: 07 June 2004 Status: Offline Points: 12	Post Options Post Reply Quote bjobra Report Post Thanks(0) Quote Reply Topic: Search Server Timouts 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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.

bjobra Members Profile Find Members Posts Newbie Joined: 07 June 2004 Status: Offline Points: 12	Post Options Post Reply Quote bjobra Report Post Thanks(0) Quote Reply 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.

bjobra Members Profile Find Members Posts Newbie Joined: 07 June 2004 Status: Offline Points: 12	Post Options Post Reply Quote bjobra Report Post Thanks(0) Quote Reply 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

bjobra Members Profile Find Members Posts Newbie Joined: 07 June 2004 Status: Offline Points: 12	Post Options Post Reply Quote bjobra Report Post Thanks(0) Quote Reply 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.

bjobra Members Profile Find Members Posts Newbie Joined: 07 June 2004 Status: Offline Points: 12	Post Options Post Reply Quote bjobra Report Post Thanks(0) Quote Reply 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.

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum