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 ......


many thanks

Andrew