> > Do I get it right that this pattern would > > take much more resources with SQLite JDBC driver? > > When you say more - relative to what? I can see non-SQLite JDBC > drivers would use a lot less client-side memory because they would not > have such a local memory cache.
More than the cache size i specified via "PRAGMA cache_size". I've expected SQLite to use that amount of memory for each database. Instead I should expect it to use that amount of memory multiplied by the number of threads. That've hit me unexpectedly; I think this should be mentioned somewhere. > SQLite is not the best solution for a high transaction volume database > anyway. Use postgres or mysql instead. But I'm not even using it with transactions. I just have multiple working threads. Every J2EE server have them. --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
