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