50,000 rows update time

[learner03]

How much time should approximately 50, 000 rows take to load?

I am using a connector of our warehouse management system and when I load the data or apply changes it take aroung 25 min to load. Is it normal? or what can I do to speed this up?

[amitchandak · Accepted solution]

@learner03 , Change these settings and try. Also increase data management cache size

Also, refer to the video from guyinacube : https://www.youtube.com/watch?v=eABg872TAJU

[amitchandak · Accepted solution]

@learner03 , Change these settings and try. Also increase data management cache size

Also, refer to the video from guyinacube : https://www.youtube.com/watch?v=eABg872TAJU

[learner03]

Hi Amit,

I will try these. Can we select the tables we want to refresh or all the tables are refreshed when we click"refresh"

[amitchandak · Accepted solution]

@learner03 , You can right click on the table and refresh it alone in reporting layer( Visualization, Data, data model)