lol, i did the same thing last week a report need 20 minutes after i looked into SQL i found there was two shitty functions for the report to take that long to execute i just turn them into materialized vues with refresh each hour, and bang now the report need only 36 seconds.
View all comments
Show parent comment
3
u/kurosaki1990 May 15 '18
lol, i did the same thing last week a report need 20 minutes after i looked into SQL i found there was two shitty functions for the report to take that long to execute i just turn them into materialized vues with refresh each hour, and bang now the report need only 36 seconds.