Re: [sqlite] SQLite on limited Memory

2006-04-25 Thread drh
"Tony Fenleish" <[EMAIL PROTECTED]> wrote: > You meantion avoid using sqlite3_get_table. I've been using sqlite 2.8.15 > and have postponed upgrading just because "it's been working". Are there > better memory handling and speed improvements for embedded devices in sqlite > 3, or are most of

Re: [sqlite] SQLite on limited Memory

2006-04-25 Thread Tony Fenleish
ots of ram and large processors? From: Christian Smith <[EMAIL PROTECTED]> Subject: Re: [sqlite] SQLite on limited Memory Date: Tue, 25 Apr 2006 15:06:34 +0100 (BST) Otherwise, avoid loading the full result set into memory as you process it. Ie. Avoid sqlite3_get_table(). Christian

Re: [sqlite] SQLite on limited Memory

2006-04-25 Thread Christian Smith
On Mon, 24 Apr 2006, Tony Fenleish wrote: >I've been developing an app on a linux embedded device with 128 M of RAM, >although the available RAM for queries is less than that. Now that the >databases are getting a little larger (120 MB), I'm having problems with >some queries that have large

[sqlite] SQLite on limited Memory

2006-04-24 Thread Tony Fenleish
I've been developing an app on a linux embedded device with 128 M of RAM, although the available RAM for queries is less than that. Now that the databases are getting a little larger (120 MB), I'm having problems with some queries that have large results. I watch my memory drop completely,