> > At present I have a "counting" callback function on "select myid from > myview" that returns the number of rows encountered before > myid=this_myid - severely inefficient. > > Any other ideas?
Count the rows with a counter as you fetch them? I'm not sure if ROWID works on a view or not... does this work? select rowid, myview.* from myview