One problem (at least in Postgres) is that you can't partially refresh the view, so it inevitably takes more time as your database grows. There's pg_ivm extensi

One problem (at least in Postgres) is that you can't partially refresh the view, so it inevitably takes more time as your database grows. There's pg_ivm extension but it limits what can be put in the view definition. Otherwise you'll have to be smart about composing it of smaller, independent views.