UK Karting - Notice Board (Chat) : Re: It was short lived sadly.

Notice Board (Chat)

Re: It was short lived sadly.
Posted by 'ghinzani' on 15 Oct 2010 @ 17:11

| View Message Thread | Reply to this message |

ghinzaniJoined: April 2003
Total Posts: 5
[ View User Profile ]

Usual story with MS SQL DB - inefficient queries slowing it down. With DB2 you can put your most regular queries in a lookup table so you are'nt doing full DB searches - it acts liek a cache. I think basically it needs some serious downtime and tuning done to it. I work with some systems with equally inefficient DB's, its not an uncommon thing.
I found the following on the specific error, the most important line is "a better approach would be to make your queries more efficient.":

http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e31-errors.html

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

This can often be fixed by "kicking" the server, e.g. hitting refresh on the affected ASP page eliminates the problem. But how about a longer-term fix?

If you have MDAC 2.6 installed, upgrade to the latest version of MDAC from MDAC Download Page. As an immediate workaround, force TCP/IP lookup in your connection string and make sure you refer to the SQL Server by IP address, not by name. For more info see Article #2082 and Article #2126.

The timeout can be caused by a name -> ip lookup. This is a problem with the version of DBNetLib.dll that shipped with MDAC 2.6 -- see KB #300420 for more information.

While a quick bandage would be to increase timeout values (see Article #2066), a better approach would be to make your queries more efficient. For many ideas, see Article #2424.

Message Thread:

Whisper It Quietly.......... by 'Newshound' (14 Oct 2010 @ 22:19)

Re: Whisper It Quietly.......... by 'TKM177' (15 Oct 2010 @ 7:53)

Re: Whisper It Quietly.......... by 'DavyBoy' (15 Oct 2010 @ 8:05)

It was short lived sadly. by 'DavyBoy' (15 Oct 2010 @ 10:34)

Re: It was short lived sadly. by 'Newshound' (15 Oct 2010 @ 12:12)

Re: It was short lived sadly. by 'ghinzani' (15 Oct 2010 @ 14:18)

Re: It was short lived sadly. by 'TKM177' (15 Oct 2010 @ 16:57)

Re: It was short lived sadly. by 'ghinzani' << You are here!

Re: It was short lived sadly. by 'DavyBoy' (15 Oct 2010 @ 17:41)

Re: It was short lived sadly. by 'ghinzani' (15 Oct 2010 @ 18:23)

Re: It was short lived sadly. by 'DavyBoy' (15 Oct 2010 @ 19:02)

Re: It was short lived sadly. by 'ghinzani' (15 Oct 2010 @ 19:04)

Re: It was short lived sadly. by 'DavyBoy' (15 Oct 2010 @ 19:36)

Post a Reply:

You may post a direct reply to this message which will appear in this thread.
To post a new or unrelated message use This Form. Top of Page
Notice Board Index

[ UK Karting Main Index ]


News	Karts & Karting	Notice Board	Market Place	Companies Directory	Tracks Directory	Events Calendar	Race Results	Photo Gallery	Links