When I open a tib_query and do a locate, a fetchall is done
(autofetchall=false). A dialog box appears saying 'fetching query
results record ..' while it fetches the 30000 records in the table.
This is slow, to the point of being not acceptable, especially
compared to the bde version of the same program. The query (see
below) uses partnumber as the order by and then as the locate field.
This field is a unique key in the table (partid is the primary key).
Is there anything I can do to speed up the locate? Am I doing
something wrong? I've checked the faqs. Thanks for any help you can
provide. (Delphi 6, IBO 4.2.fr)

SELECT PARTNUMBER,PARTID,QTYONHAND,UOFM
FROM TMA_PART
ORDER BY PARTNUMBER


Stan Walker