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]

Reply via email to