Hi,
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?

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


Gordon