Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
AmirMoha
Contributor III
Contributor III

MySQL fetch data between Qlik Saas and Qlik Desktop

Hi all, 

Would anyone be able to help/clarify this please?

Why does a MySQL enterprise datasource take longer in Qlik Saas than Qlik Desktop?

Same table, same dataset, same credentials

Labels (4)
3 Replies
Chirantha
Support
Support

One possibility is that the connection to the MySQL server is slower when using Qlik Saas, which could be due to network latency or other factors. Another possibility is that there are differences in the way data is fetched and processed between Qlik Saas and Qlik Desktop, which could result in slower performance on Qlik Saas. Without more information, it’s difficult to determine the exact cause of the issue. 

AmirMoha
Contributor III
Contributor III
Author

Hi Chirantha, 

 

Thanks for your reply, what information can I provide that would clarify the exact issue?

AmirMoha
Contributor III
Contributor III
Author

The data is only 1.6millon rows and 14 columns

the data is loaded in Qlik desktop within 3 minutes but in Qlik Saas it's over 20 minutes and it is not even half of the data