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. I tried setting the pragma cached_pages to 10 thinking that would set the amount of memory consumed to around 10K. It didn't work. Is there a way to set the amount of memory consumed by SQLite to around 20K? Ray
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------

