Many Small Queries Are Efficient In SQLite
added on 2021/02/16 @ 11:25:18 | 714 views| category: programming
- 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 whichever technique works best for the task at hand.
tags: #sqlite #database