> Thanks for confirming. The more people shout up and say that they
> see this, the more chance we'll have of getting it fixed.
>
> I also see an instant (less than 1ms) disconnect occasionally - say
> 1 time in 4 - and the rest are around 10 secs.
>
> Note that the delay seems to be invariant of processor speed - on a
> fast dual athlon it's the same length as on a much slower 700 MHz
> mobile P3 with a slow HD. So I don't think it's anything to do with
> cacheing or file access - the delay would be much shorter on fast
> machines.

I'll pipe up then, and also echo that I've seen this. I had always chalked
it up to the fact that I didn't do the complete process of removing the
system restore link to gdb files (I just disabled the system restore service
in XP, and went on with life). I also will occasionally see fast
disconnects from the database, but the rule is that it takes a long time for
the last client connected to disconnect. My workaround on my development
machine (Because I hate having to wait 10-15 seconds to get back to Delphi
when I'm developing) is to have another app open with a connection to the
database (IBExpert, IBConsole, some dumb little app I wrote, it doesn't
really matter) permanently. The slowness, when it happens, will happen on
the last client application to disconnect from the database, so my program
will return to Delphi immediately since there are other open connections.
Also, it's important to note (I think) that when my machine is in the
process of this 10 second disconnect, that no other program can connect to
any firebird database on my machine. It looks for all the world like some
sort of timeout issue, like the firebird server thinks that the connection
has died abnormally, so it's trying to reconnect or something.
Not having looked at the code, though, I'm probably completely wrong. :)

- Jason