[DUG] Firebird connections / queries

[Paul Lowman]

Hi all

I am using Firebird / dbExpress in an industrial control application and
wondered about the following points:

Is it OK to open a connection to a database and leave it open for extended
periods (ie: days) or should I open and close the connection on demand?

Similarly is it OK to prepare queries when the app starts and leave them in
a prepared state for extended periods?

My instincts tell me that this may be a bad approach ...

Any opinions welcome ...

Cheers

Regards

Paul Lowman

paul_lowman at xtra.co.nz