[DUG] Firebird connections / queries

[Trevor Jones]

Phil,
  If you only read from the database during your transaction, then call
rollback, IB/FB will turn this into a commit.

Ann Harrison has a well written guide to what goes on internally here:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_expert4


-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
Behalf Of Phil Middlemiss
Sent: Wednesday, 27 July 2005 5:02 p.m.
To: rohit at cfl.co.nz; NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Firebird connections / queries

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: