Forum Home Forum Home > Site News, Newbies, Help and Improvements > Report bugs here
  New Posts New Posts RSS Feed - SQL Timeout
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedSQL Timeout
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
chopper View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: July 13 2005
Location: Essex, UK
Status: Online
Points: 20032 		Direct Link To This Post Topic: SQL Timeout
    Posted: September 16 2005 at 15:03
I tried to search for a thread about the lyrics to "Blinded by the light" but I keep getting an SQL timeout error-

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

/forum/search.asp, line 356

It should be possible to increase the timeout value.
Back to Top
MikeEnRegalia View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: April 22 2005
Location: Sweden
Status: Offline
Points: 21561 		Direct Link To This Post Posted: September 16 2005 at 15:06
^ try searching each forum category at a time.
Release Polls

Listened to:
Back to Top
chopper View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: July 13 2005
Location: Essex, UK
Status: Online
Points: 20032 		Direct Link To This Post Posted: September 19 2005 at 08:03

Originally posted by MikeEnRegalia MikeEnRegalia wrote:

^ try searching each forum category at a time.

Thanks for the suggestion Mike, but I was only searching in one category at the time.
Back to Top
Snow Dog View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: March 23 2005
Location: Caerdydd
Status: Offline
Points: 32995 		Direct Link To This Post Posted: September 19 2005 at 08:33
Try restarting your pc, you may get a better connection.
Back to Top
goose View Drop Down
Forum Senior Member
Forum Senior Member
Avatar

Joined: June 20 2004
Location: United Kingdom
Status: Offline
Points: 4097 		Direct Link To This Post Posted: September 20 2005 at 10:20
SQL is server end though.
Back to Top
MikeEnRegalia View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: April 22 2005
Location: Sweden
Status: Offline
Points: 21561 		Direct Link To This Post Posted: September 20 2005 at 10:35
^ as far as I know, the timeout is caused when the result is too big. So either the timeout value is increased (which M@x presumably won't do) or you have to use more words in the search and make it return threads which contain ALL of the words.
Release Polls

Listened to:
Back to Top
Easy Livin View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator / Retired Admin

Joined: February 21 2004
Location: Scotland
Status: Offline
Points: 15585 		Direct Link To This Post Posted: September 20 2005 at 14:28
I'm not technically gifted, but I think the time out is more to do with the amount of data the search is having to trawl through, due to the number of posts and threads now on the forum. The error only seems to appear when you try to search on the "body text" which looks at every word in every post in every thread.
Back to Top
MikeEnRegalia View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: April 22 2005
Location: Sweden
Status: Offline
Points: 21561 		Direct Link To This Post Posted: September 20 2005 at 14:42
^ the funny thing is that I've used that search many times (all threads, message bodies) and got no timeout. I don't know if it was pure coincidence, but I got the impression that it really depends on what you're searching for - it seems to take the longer the more results it finds.
Release Polls

Listened to:
Back to Top
Citanul View Drop Down
Forum Senior Member
Forum Senior Member


Joined: June 14 2005
Location: South Africa
Status: Offline
Points: 430 		Direct Link To This Post Posted: September 21 2005 at 02:45
It has happened to me a few times, but if I wait and then try a bit later there's usually no problem.
Be or be not. There is no question. - Yoda, Prince of Denmark
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.219 seconds.
Donate monthly and keep PA fast-loading and ad-free forever.