6 ms·
"The SQLite website (https://www.sqlite.org/) uses SQLite itself, of course, and as of this writing (2015) it handles about 400K to 500K HTTP requests per d
by pstadler 12y ago
"The SQLite website (https://www.sqlite.org/) uses SQLite itself, of course,
and as of this writing (2015) it handles about 400K to 500K HTTP requests
per day, about 15-20% of which are dynamic pages touching the database.
Each dynamic page does roughly 200 SQL statements. [...]"
Wait... What? They're saying that their dynamic pages are executing 200 SQL statements per request?
Off-topic: I enjoyed reading this article which was posted here a while ago http://www.sqlite.org/testing.html http://www.sqlite.org/testing.html
- mutagen 12y ago200+ queries for a simple dynamic page doesn't surprise me. Once you add some dynamic features it's easy to start sticking all kinds of stuff in the database. Let me check some sites I run: Medium complexity Drupal 6 site: 200-300 queries Wordpress site with accretion of plugins over the years: 100+ queries Drupal 7 site: 100+ queries Those totals might be inflated due to having administrative menus active. Many of these are key/value lookups which can be accelerated by serving from Memcached or Redis, although I imagine SQLite dishes them out pretty quickly as well.