Partially true, I forget to call sqlite_freemem on error
But my process continue to use too many Ram.
I've found some define but the documentation is not clear
In pager.h
#define SQLITE_PAGE_SIZE 512
/* default 1024*/
In sqlint.h
#define MAX_PAGES 100
/* default 2000*/
#define TEMP_PAGES 50
/*default 500*/
#define MAX_ATTACHED 2
/* default 10*/
#define SQLITE_OMIT_AUTHORIZATION 1
#define SQLITE_OMIT_INMEMORYDB 1
#define SQLITE_OMIT_PROGRESS_CALLBACK 1
#define MAX_BYTES_PER_ROW (5*1024)
/* default 1048576*/
What can I do more ?
Eric JESOVER
http://eric.jesover.net
-----Original Message-----
From: Lindsay Mathieson [mailto:[EMAIL PROTECTED]
Sent: Tuesday 16 December 2003 22:44
To: Eric JESOVER
Subject: Re: [sqlite] Used Memory problem
Eric JESOVER wrote:
>How can I limit the amount of ram sqlite use?
>I have a 4 MB database after some select insert the amount of ram using
>by the process is 100 MB.
>
>
100 MB ! I suspect a problem with your code rather than SQLite
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]