Many Small Queries Are Efficient In SQLite

1. Executive Summary 200 SQL statements per webpage is excessive for client/server database engines like MySQL, PostgreSQL, or SQL Server. But with SQLite, 200 or more SQL statement per webpage is not a problem. SQLite can also do large and complex queries efficiently, just like client/server databases. But SQLite can do many smaller queries efficiently too. Application developers can use whicheve

[tmatsuu]

Webサイト1ページ表示するのに200回クエリーが必要でもN+1が発生しても大丈夫。そう、SQLiteならね。確かにサーバ間通信のレイテンシが発生しないし効率は良いはず。ただし複数台構成にするのは難しい。