Jason Morehouse wrote:
We are currently using mysql. What is the comparison to opening a database with sqlite vs connecting to the daemon with mysql? Our current box has seen 300+ connections to the sql server at at once. Can we expect that having 300 databases open with sqlite wont be a problem?
While I suspect that SQLite could handle the large number of connections, in general a database server will handle high levels of concurrency better than a disk based database. A lot will depend on the specific usage though. If it's a high percentage of reads, you'll probably be okay with SQLite, just because it's fast and very efficient. That will probably change if most of the clients are writing, or even if a high enough percentage are writing. Because of SQLite's very coarse-grained locking, writes on a busy database can be problematic.
Clay Dowling
