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

personally I don't think either method is acceptable. For this you need a
where clause. I'm sorry but I think your design is deficient if you cannot
implement it this way (IMHO)
Alan