| Subject | Re: [firebird-support] Re: Firebird function to test if a database connection is not disconnected? |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2009-05-14T10:04:49Z |
> Thank you so much Helen. I was looking for something economical and generic that could be used to test the connection state.Actually, not at all. Depending on server version and implementation
>
> SELECT 1 FROM RDB$DATABASE is absolutely perfect!
it can take up to 9 round trips to server. Too much overhead for my taste.
I use isc_database_info() call which always takes exactly one round trip.
SY, SD.