[sqlite] Memory managment and B-Trees

Hello All: I have a question. I am trying to make SQLITE favor writing to disk than to store in memory with no luck!. I tried : sqlite3_soft_heap_limit(); rc = sqlite3_exec(ppDb,"PRAGMA cache_size = 10;",NULL,NULL,NULL); I tried to modify the page size, but with no

RE: [sqlite] Enabling SQLITE_ENABLE_MEMORY_MANAGEMENT on Visual Studio.Net

Hello Brandon: Thanks for your replay. Can you tell me what directive you use in the make file in Linux to enable that. I am trying to reduce the memory usage of SQL. DO you have any ideas about how I can do that on Windows (other thank using SQLITE_ENABLE_MEMORY_MANAGEMENT ) Thanks