Subject Fetch lag
Author Tetram Corp

i made a program in Delphi (using IBX) with FB1.5 and during a "while
not eof" loop, each X fetches, my application freeze for 60s (neither
more nor less)

in pseudo code, my loop is:

SQL = "SELECT FROM aView" (neither group by nor join, just cast and
substring on a single table)
while not EOF do begin
if DoSomeSelectInsertUpdateExecuteProc then CommitRetaining

(All in the same transaction)

is it a known problem? is there a solution? (except having vacations :) )