On Fri, May 01, 2015 at 04:23:26AM -0700, Sanjay Minni wrote: > however in your notes below you mentioned that you used a dump of large > size. My question is when faced with such large row sets how do you limit > the size of data read in the select statement .
This web page suggests how to deal with this: https://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor > another doubt I had was from the example code below from the NBSQLite3. > is rs close at the right place - would it be closing the connection ? > > res := db beginTransaction. > > rs := db execute: '...'. > rs close. > > res := db commitTransaction. rs holds an NBSQLite3ResultSet instance. Closing it does not close the the database connection object which is an NBSQLite3Connection instance. In my example I had failed to close the result set object. :-P Resource finalization is still tricky at times. I have a few broken images lying around, mostly due to that. Pierce
