|Subject||RE: [IBO] Which is faster? Select First 3000 or MaxRows = 3000 ?|
> > > It's efficient real-time processing.I should also add that in IBS_Base there are some methods designed to
> > 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.
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