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