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 [EMAIL PROTECTED] _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
