|Subject||RE: [IBO] Which is faster? Select First 3000 or MaxRows = 3000 ?|
> I have a table containing just 8 fields, however there may be uptoIt highly depends on what you are doing in the where clause.
> 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 ......
Tell us more about what you are doing. So far I'm inclined to think you are
not approaching things in the best way.