There is no problem with leaving the connection open. We leave it open permanently in some apps that should run 24/7.
With the number of queries in our apps, I dont leave them prepared. To minimise resource usage especially with IBO, I reuse the queries for multiple uses instead. But there should be no problems. Paul, Feel free to come for a visit at work :-) 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
