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?
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