[DUG] Firebird connections / queries

[Phil Middlemiss]

Ah, I was just about to ask if, for SELECT queries, it was preferable to 
rollback or to commit. But I guess that answers the question. What is 
the long term effect on a server if I keep using rollbacks?

Phil.

Rohit Gupta wrote:

>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
>======================================================================
>
>
>_______________________________________________
>Delphi mailing list
>Delphi at ns3.123.co.nz
>http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>
>  
>