Re: PostgreSQL vs Firebird

From: Martijn Tonies (m.tonies_at_upscene.removethis.nospam.com)
Date: 03/18/05


Date: Fri, 18 Mar 2005 21:04:38 +0100


> > As most people use TCP/IP to connect to Firebird, and Firebird
> > has a sort of "ping" when it comes to connections, I guess as soon
> > as the socket is being closed, the "ping" would fail and Firebird
> > would mark the connection as "closed". Now, this ping thingy is
> > configurable so that might make a difference as well.
> >
> Suppose the workstation is still alive, but the app crashed. Wouldn't
> the ping still be successful, even though the db connection is beyond
> recovery?

No, it wouldn't - the "check alive" command tries the command
at the port it was using for the connection. As the port has been
closed, it will be "disconnected".

-- 
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com