i was quite surprised when dealing with android's sqlite implementation. suppose i have db with a table counting moro or less 40000 rows.
now i do query 'select field from table'. no 'where' clause so result set should have all rows. and i was surprized that Cursor 'allocates' probably all the rows since it takes ~10 secs to db.query() + cursor.moveToFirst() afaik sqlite on PC makes working set 'virtual' doing hard job on demand when one wants to fetch next rows (i did the same with python 2.5 which has sqlite support and couldn't measure time of select + fetching first row since it was so fast) is my assumption correct that Cursor allocates all the rows not doing lazy allocates? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
