Article View: borland.public.interbase.opensource
Article #153Re: IB6 slow to connect
From: Bill Todd
Date: Tue, 06 Sep 2005 17:47
Date: Tue, 06 Sep 2005 17:47
26 lines
2199 bytes
2199 bytes
Stephan wrote: > > All right, fair enough. But what I am really interested to know is > what IB is doing on the first connection. All subsequent connections > to the database go relatively smooth, but the first connection can > take as long as half an hour. That description fits the Microsoft TCP/IP stack bug perfectly. The first connection is slow and all subsequent connections are fast. I have no knowlege of the details of the TCP/IP problem. I have been told that it affected other programs besides InterBase as well. > > Is it performing a database sweep, garbage collecting? It is almost > as if IB configures itself for access on the first connection. If > I restart the server, the first connection again takes this long, > but then not again until the server is restarted. What does IB do? It is not IB doing anything. It is IB tring to establish a connection with Microsoft's buggy TCP/IP stack. If you don't believe me search the newsgroup archives. You will find a vast number of posts about this problem when it first surfaced. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<431dd61e$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<4317f070$1@newsgroups.borland.com> <431856e7$1@newsgroups.borland.com> <431be9ec$1@newsgroups.borland.com> <431c850c$1@newsgroups.borland.com> <431dade3$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,5f8096a5d8754aaf
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: IB6 slow to connect
Newsgroups: borland.public.interbase.opensource
References: <4317f070$1@newsgroups.borland.com> <431856e7$1@newsgroups.borland.com> <431be9ec$1@newsgroups.borland.com> <431c850c$1@newsgroups.borland.com> <431dade3$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.17.5.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <431dd61e$1@newsgroups.borland.com>
Date: 6 Sep 2005 10:47:10 -0700
X-Trace: newsgroups.borland.com 1126028830 216.207.211.19 (6 Sep 2005 10:47:10 -0700)
Lines: 28
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail