On 7/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Any thoughts/brainstorming would be great from anyone :) > > Personally I don't have much experience with programming a database and > the theory in it. But I suppose that in order to be able to go backward, > the results already iterated through must be kept(at least a reference to > it, something like rowId). If setToLast is used, I must use the > sqlite3_step in order to find the last entry and then cache the other > results. > > Is there an easier way??
I cache the items I'm displaying in an STL vector (C++). If the user moves to a page where I have no data I load it from the database as needed. I was considering loading data in the background in case the user might need it since I can predict what they might do relatively easily.