> In pcache1Fetch, sqlite mutexes around the cache handling, which appears to > be causing significant waits/scalability issues in my application. If I > disable this mutex, the application crashes.
Why do you think that this mutex causes significant waits? Anyway ... > Is it possible to cache on a thread-by-thread basis such that no mutexes are > necessary? You can make your own pcache implementation which will work independently between threads and thus probably consume a lot more memory than it is now. Pavel On Mon, Oct 18, 2010 at 12:25 PM, Powell, Jeff <jeff.pow...@sap.com> wrote: > I'm seeing some scaling issues (which I'm hoping someone else has encountered > before). I have an application which utilizes multiple threads, each of > which never writes to the database, and none of which shares its cache. > > In pcache1Fetch, sqlite mutexes around the cache handling, which appears to > be causing significant waits/scalability issues in my application. If I > disable this mutex, the application crashes. > > Is it possible to cache on a thread-by-thread basis such that no mutexes are > necessary? > > -Jeff > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
