On Tue, 27 Apr 2010 12:53:42 -0700 (PDT), Radcon Entec <[email protected]> wrote:
>Michael, > >Thank you for your suggestion. I tried this in the ADO.Net >world by adding "cache_size=10" to my connection string. >It had a small effect, but it did not come close to fixing >the problem. > >But you are saying to change it inside the source code >of SQLite itself. This is possible, and I will try it, >but we have built the SQLite code into a standard DLL >used by many of our applications. That si not necessary, you can influence it through the API or with PRAGMA statements. >I would much rather >have a way to clean up the cache that can be done >without having my application use its own, custom-built >version of SQLite. Closing the connection will clear the cache. There's more: PRAGMA [default_]cache_size sqlite3_soft_heap_limit(int) sqlite3_release_memory(int) sqlite3_memory_*() >RobR -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
