Re: PostgreSQL vs Firebird
From: Martijn Tonies (m.tonies_at_upscene.removethis.nospam.com)
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
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