James,


james_027 schrieb:

> Hi Helen
>
> Well in case you haven't experience. At one time in my development, I
> encounter having to go thru a records of a inventory log. Reason for
> this is because in a private company where their inventory is
> eventually poor and prone to errors. We have to check the physical
> inventory against the inventory in the computer. To cut it short
> scrolling thru a thousand of records is sometimes necessary though it
> is every rare. So in this case if improvements could be made it is
> much better.

Just some comments for speeding up:

If you have to go through large resultsets without having to show them
use a TIB_Cursor instead. It's much faster.
And if you process a lot on the fields of the records it's much faster
if you use Fields[index] instead of FieldByName.

And if it's just a comparism of some data vs. some other data think
about doing it within a stored procedure.

Luc.