---- [EMAIL PROTECTED] wrote: > <[EMAIL PROTECTED]> wrote: > > ---- [EMAIL PROTECTED] wrote: > > > <[EMAIL PROTECTED]> wrote: > > > > I completed my analysis of the SQLite database memory usage and I was > > > > surprised to find that SQLite consumes so much memory. I ran my test > > > > case (creates 31 tables) and found that SQLite consumed 545,231 bytes > > > > of malloced memory before it started giving it back. > > > > > > > > > > 100K? yes. 20K? no. > > > > > What is the set of commands to do this? > > Ray > > > > There is no "command" to make SQLite use less memory. > Rather you have to use careful engineering to keep > the memory usage to a minimum. Start with this: > > PRAGMA default_cache_size=10; > > Then close your connection and reopen it and do this: > > PRAGMA cache_size; > > Verify that you got a "10" back so that the change took. > > When you compile, you will want to leave out as much stuff > as you do not need using SQLITE_OMIT_* flags. You will > want to take care in your use of SQL so that you do not > specify SQL statements that inherently require a lot of > memory. You'll probably want to make use of > sqlite3_soft_heap_limit() and sqlite3_release_memory(). > Stay far, far away from sqlite3_get_table(). And so > forth. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > Thanks for the info. Ray
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
