I have a slide explaining the N + 1 problem. Sometimes it is not a problem with bounded and controlled number of entities. Sometimes it scales horribly poor. The single query with join can produce Cartesian product, that, under special circumstances, can cause out of memory error. A balance approach to this problem is 1 + batches queries.
2026-07-19 16:57:51
0
gerlaxie :
A good collection here. i learnt something today
2026-05-27 16:30:59
1
thgandalph :
actuall it is 2N not N+1 😁
2026-05-30 07:01:50
0
iamtheonlyted :
having a good database is the most important part of the system. most full stack don’t even know what indexing is.
2026-05-27 11:56:33
1
MimsyMad :
Good list but 2 minor issues; NULL is literally the default when the column sets it as such. Also beware claiming "most users dont..." unless you can back it up.
2026-05-27 11:39:37
0
To see more videos from user @theforeverknights, please go to the Tikwm
homepage.