Subject RE: [IBO] Which is faster? Select First 3000 or MaxRows = 3000 ?
Author Jason Wharton
> I have a table containing just 8 fields, however there may be upto
> several million data records within this table.
> I need to bring the record set back in batches of approx 3000 records.
> I'm using an IB_Query and was hoping someone could advise if it is
> quicker/more efficient to use the following SQL statement or set the
> MaxRows property on the query.
> Select First 3000 * From MYTABLENAME
> WHERE ......

It highly depends on what you are doing in the where clause.

Tell us more about what you are doing. So far I'm inclined to think you are
not approaching things in the best way.