-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 J Jayavasanthan wrote: > In the process I noticed that the memory grew to enormous proportions that > terminated my app with OutOfMemory issue.
How do you know it is SQLite consuming the memory and not your code? You can use sqlite3_status to find out how much memory SQLite is using. > I thought that only the sqlite3_get_table function was supposed to fetch the > rows in the memory, am I wrong or I missed some PRE_PROCESSOR while > compiling the static library which resulted in such an issue, Your understanding of how SQLite works is correct - it calculates each result row on demand. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkk6Z7gACgkQmOOfHg372QRzRQCeJRqL2Y53+i+WnaUQgcbjb84E e4QAmwSfvrGsJJIGn6/QUOoGAc1uWPL6 =Hyke -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
