Gordon,

> I have a very simple situation where I have about 20-50 records in a
> table.. Im opening it , and looping through it, many times a second..
>
>
> The data doesnt change very often, so I want to just open it and leave
> it open..
>
>
> 1. I am assuming that as long as I do a fetchall , I should have them
> all in memory?

Yes, and if you want the table to stay current you should call Refresh from
time to time.

> 2. Is there any way to tell it to give it to me in a certain order? Or
> is that onlyfor the Query components?

Yes, you can set the IndexFieldNames property or you can set the IndexName
property and this will control the sort order. This will cause your query
to be re-executed on the server as I don't do client-side record sorting.

Jason L Wharton