I came across this article via a Hacker News post. This mentioned that SQLite was able to handle –
400 write transactions per second, and thousands of reads
I’ve recently started implementing applications with SQLite and with journal_mode set to WAL so that multiple concurrent writes could be done. However, I was curious to confirm the concurrent transactions number.
Earlier, I have used SQLite for development but usually on production we would face challenges with the notorious Database is locked error, we would move to Postgres or MySQL. However, I’ve always felt that for 90% of the applications we create don’t require these and was keen to back it up with numbers.
So, I decided to use Apache JMeter to try load testing a sample application.