Forum Discussion

kayla_hammond's avatar
kayla_hammond
Data Storage
10-20-2021
Solved

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

1 Reply

Replies have been turned off for this discussion
  • Oleksii_S's avatar
    Oleksii_S
    Sisense Employee

    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