| Author |
 Topic Search  Topic Options
|
klr3 
Groupie
Joined: 20 February 2003
Status: Offline
Points: 103
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: SQL Search Error ’80040e31’
Posted: 29 April 2004 at 4:47am |
Very time some one try to search in message body on the serach pages, I always get following error:
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/forum/search.asp, line 356
Iīm using MSSQL and WWF version 7,51a...
Anyway to fix this?
I donīt have any problems when seaching in subject or members..
Please help! 
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 April 2004 at 7:11am |
|
Increase the timeout property in the common.asp file.
|
|
|
|
klr3
Groupie
Joined: 20 February 2003
Status: Offline
Points: 103
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 April 2004 at 7:27am |
Thanks Borg, but that does not work. Timeout is now set 180, but the result is still the same. I think my provider has a default timeout...  But i donīt understand why the error only displays when searching in the message body???
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 April 2004 at 7:50am |
|
Maybe your web host can shed light on this.
I have seen this error before when the SQL server is located at a
different geographical location to the web server, thus the data was
taking time to travel across the Internet.
|
|
|
|
klr3
Groupie
Joined: 20 February 2003
Status: Offline
Points: 103
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 April 2004 at 8:04am |
Thatīs not the problem here as the servers are located i the same server room, and in same country...
Anyway, Iīm planing to upgrade the forum to newest version, also the MSSQL. Also I now i oprder our own private server with private SQL, so we no longer have to share with others...
Expensive, allthough...
Hopefully that will improve the preformance ?!?
Thanks again for your quick support... I, and our 10.000 daily users, love your forum - keep up the good work!
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 April 2004 at 9:09am |
|
If your server is somewhat busy and your database for the forum somewhat large it can easily timeout. There had to be a sacrifice made in SQL performance to make the search more interoperable between access and sql versions. if you understand a little about sql, t-sql etc. it is easily possible for you to improve search performance. The reason why it times out only in body search is, that it is going through text fields which naturally takes longer then some short char fields.
|
|
|
|
klr3
Groupie
Joined: 20 February 2003
Status: Offline
Points: 103
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 May 2004 at 3:33pm |
 klr3 wrote:
Very time some one try to search in message body on the serach pages, I always get following error:
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/forum/search.asp, line 356 ....
|
Now I have opgraded the forum to 7.8, got our own expensive server with SQL along, on the same machine...
Anyway, I still get the error, when trying to search in the body field.
Total posts right now is about 95.000...
Does anyone have any solution to this problem?
regards,
Kenneth 
|
|
klr3
Groupie
Joined: 20 February 2003
Status: Offline
Points: 103
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 May 2004 at 9:09am |
Still no answers??? Please help - I donīt know what to do??? I tried to copy the data from the SQL to Access, and guess what... Now itīs possible to search in the body field (in Access), but still this search returns the mentioned error code... Please note, that the database is NOT an option! What am I, and my web host, doing wrong??? To Borg:If you in any way can give some exclusive support, Iīm accepting you invioce!
|
|
