kayla_hammond
10-20-2021Data Storage
Live Data Model Performance
What is the best way to improve performance of live data models where granular data nodes are required and contain millions of records?
- 10-26-2021
Hey there,
Basically, you need to make database optimization in order to have the query executed fast so Sisense would be able to serve it in a fast matter. You can achieve this by limiting the amount of the data in the table, using a table instead of the view, or choosing the correct amount of the columns in the pivot table. Please let me know if you need additional assistance on this.
Sincerely,
Oleksii