[DUG] Firebird connections / queries

[Rohit Gupta]

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" <paul_lowman at xtra.co.nz>
To:             	"Delphi List" <delphi at delphi.org.nz>
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 <delphi at ns3.123.co.nz>
	<mailto:delphi-request at ns3.123.co.nz?subject=unsubscribe>
	<mailto:delphi-request at ns3.123.co.nz?subject=subscribe>

[ 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

paul_lowman at xtra.co.nz

_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
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 rohit at cfl.co.nz  or  r.gupta at xtra.co.nz
======================================================================