Re:Speeding up SQL queries by orders of magnitude using UNION
by slt2021 on Saturday March 20, 2021 @10:03PM
(#26527580)
denormalization aka memoization aka "dynamic programming of SQL" :-) - all three provide speed-up because they compute value once and reuse it later
[ Parent
| on HN ]
Re:Speeding up SQL queries by orders of magnitude using UNION
by mtone on Sunday March 21, 2021 @12:44AM
(#26528179)
Except that your source of truth aka your raw data is now memoized, hardly a win. This is not a goal of memoization or dynamic programming at all.
Perfect for a reporting database though.