Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Shoes
Contributor II
Contributor II

Preview data in Select Data = SELECT COUNT(*)

Hi, 

I updated Qsense to August 2021 and I see strange behavior on previewing data from database. Under the hood Qlik Sense giving question to database

SELECT COUNT(*)....

Why made this decision to make this very very unoptimatized query as default to every table ?! This kills database.. imagin 20xdeveloper doing this question... on table with 100bilions rows... They will wait for resuls ages.. 

So my question is .. how to turn this off ??

Thx for help

 

Labels (1)
2 Replies
boguslaw_gmitru
Partner - Contributor III
Partner - Contributor III

Hi, I believe that you use Data Vizard instead of script editor. Am I right?

https://community.qlik.com/t5/Knowledge/Data-preview-hangs-when-loading-from-ODBC-OLE-DB-connection/...

 

Shoes
Contributor II
Contributor II
Author

Hi, I used Data Vizard yes, but everyone using this because this giving us all initial data fields to developing , of course is another way but more inconvenient. So this fix is very HOT, please do this as highest priority. Thank You