Subject Re: [firebird-support] fastest dummy query
Author Helen Borrie
At 02:13 PM 19/03/2004 +0000, you wrote:
>Hi!
>
>Is there a way to keep the connection active from the client side,
>other than using dummy query + timer? If not, what would be the
>fastest query? Select 1 from rdb$database?

Just put this dummy query in a **read-only read committed** transaction on
its own and keep the transaction uncommitted. No need for a timer. For
tidiness, just remember to commit it as part of your disconnection routine.

/heLen