On 7 Mar 2006 at 21:21, jimbehr3446 wrote:

>When there is no ORDER BY clause it would be faster for FB to just
>return the first 50 that match. But it does not appear to work that
>way. And I have not been able to find a workaround.

The workaround is simple: don't use FIRST clause and limit number
of fetched records at client side (call isc_dsql_fetch() appropriate
number of times). I hope you don't use some stupid compiler (like
VFP)...

--
SY, Dimitry Sibiryakov.