cancel
Showing results for 
Search instead for 
Did you mean: 

Live Data Model Performance

kayla_hammond
7 - Data Storage
7 - Data Storage
What is the best way to improve performance of live data models where granular data nodes are required and contain millions of records?
1 ACCEPTED SOLUTION

Oleksii_S
Sisense Team Member
Sisense Team Member

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

View solution in original post

1 REPLY 1

Oleksii_S
Sisense Team Member
Sisense Team Member

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

View solution in original post