Subject RE: [IBO] Which is faster? Select First 3000 or MaxRows = 3000 ?
Author Jason Wharton
> > > It's efficient real-time processing.
> >
> > Thank you *very* much for your input, Jason.
> > I suspect the above will be very useful.
> >
> > Regards,
> >
> > /Dany
>
> Be sure to have a look at the IBS_Base.pas module. Much of
> what I've talked
> about is built-in to this base class service module.

I should also add that in IBS_Base there are some methods designed to
process queues (records fetched from a TIB_Cursor) and in one of them I use
the equivalent of MaxRows to determine a "batch" size that will receive a
Commit. It would be inefficient to commit for every item of a queue but it
could also be too long to do an entire batch without ever doing a commit.

So, to finally arrive at an answer to your question, MaxRows is likely
faster.

Jason