If you configure TIBOTable properly it won't require to have everything
pulled into the buffers.

It's not super-easy and it may not even be fully documented, but essentially
you need to make sure the indexes are setup and that there is an ascending
and descending index available as well as KeyLinks.

Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Stephen Boyd
> Sent: Thursday, March 30, 2006 6:52 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Re: Simulating ISAM files using a TIBOTable component
>
>
> Thanks for your reply. Since yesterday I have done some more
> research
> into TIBOTable. By turning on the SQL monitor it seems as though the
> FIndKey method does a sequential scan through the table to
> find what it
> wants. Definitely a time waster. Once you have been all the way
> through the table TIBOTable appears to use a cache to
> retrieve records
> which is very fast but not very useful since doing a COMMIT
> invalidates
> the cache.
>
> Looks like I'm going to have to do this the hard way using a
> TIB_Cursor
> and generating my own SQL to make it happen the way I want it to.