3 ms·
> Postgres suffers from the n+1 problem, while SQLite does not. ?
by tangjurine 3y ago
> Postgres suffers from the n+1 problem, while SQLite does not.
?
- deleted 3y ago[deleted]
- randomdata 3y agoIndeed.
- emseetech 3y agoIt’s worth elaborating: N+1 Queries Are Not A Problem With SQLite https://www.sqlite.org/np1queryprob.html#:~:text=N%2B1%20Queries%20Are%20Not%20A%20Problem%20With%20SQLite&text=The%20SQLite%20database%20runs%20in,SQLite%20is%20not%20the%20problem https://www.sqlite.org/np1queryprob.html#:~:text=N%2B1%20Que....
- javcasas 3y agoMeaning insertion sort does not suffer from the problems that made us construct quicksort because we optimized the insertion a lot (at a tradeoff that we will not specify).