Re:We Can Do Better Than SQL
by 3pt14159 on Tuesday August 11, 2020 @10:10AM
(#24120392)
For monster queries (thousands of lines of SQL) I find that temporary tables are also great. You can index them and, depending on your DB and its settings, they're usually held in RAM so they're super fast.
[ Parent
| on HN ]
Re:We Can Do Better Than SQL
by sumtechguy on Tuesday August 11, 2020 @10:40AM
(#24120728)
That is implementation specific. In some db's putting an index on a temp table does nothing. In later versions of the same db it does but only in particular cases. Make sure you read the docs around that.