Paul, just make sure that you do not leave transactions open.... either have readonly ones or commit/rollback as soon as possible. And avoid rollback, Firebird seems to treat them as transactions in limbo.
From: "Paul Lowman" <[EMAIL PROTECTED]> To: "Delphi List" <[email protected]> Date sent: Wed, 27 Jul 2005 15:51:54 +1200 Copies to: Subject: [DUG] Firebird connections / queries Send reply to: NZ Borland Developers Group - Delphi List <[email protected]> <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> [ Double-click this line for list subscription options ] 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 Regards Rohit ====================================================================== CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH (649) 489-2280 FX (649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] ====================================================================== _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
