Re:SQL: One of the most valuable skills
by magicalhippo on Wednesday February 13, 2019 @06:16PM
(#19158102)
Well, for immediate refresh materialized views, how do you keep your non-sql solution up to date?
For manual refresh, I agree, either non-sql or just plain temp tables is a decent alternative. In our case the views do a lot of joins and subqueries, so we've mostly used temp tables.
For manual refresh, I agree, either non-sql or just plain temp tables is a decent alternative. In our case the views do a lot of joins and subqueries, so we've mostly used temp tables.