alt Hacker NewsBecause it doesn't make a difference, because `SELECT 1` doesn't need to touch the database:
Running 100,000 `SELECT 1` queries:
PostgreSQL (localhost): 2.71 seconds
SQLite (in-memory): 0.07 seconds
SQLite (tempfile): 0.07 seconds
Replies
j45 • today at 7:34 PM
Queries for small SaaS are usually in the thousands of records, if not hundreds.
locknitpicker • today at 10:24 AM
> Because it doesn't make a difference, because `SELECT 1` doesn't need to touch the database:
I hope you understand that your claim boils down to stating that SQLite is faster at doing nothing at all, which is a silly case to make.
➕ show 1 reply
Why are you doing meaningless microbenchmarks?