Forum Discussion
Perfomance Questions
In this video, they talked about having an aggregated table on the live connection. Check if this can help
Hi Macwin ,
“Should I create the hidden aggregated table in bi querie editor or should I create a aggregated table in my SQL server.”
It's better to create the hidden aggregated table in Edit Queries.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I switched to azure database for postgressql
Count with a Filter takes 101.000 ms and distinct count with a filter takes 37000 ms (Data for single day)
Should I create the hidden aggregated table in bi querie editor or should I create a aggregated table in my SQL server.
To your Question -> there is something called timescaledb, but its only for bigger data. We going to setup up this later but at the moment there is no need since Im only testing with data of 1-3 days.
Hi Macwin ,
“Should I create the hidden aggregated table in bi querie editor or should I create a aggregated table in my SQL server.”
It's better to create the hidden aggregated table in Edit Queries.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.