Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Direct Query slow loading

I am attempting to use Direct Discovery for the first time.

I have a table holding 70 million rows of textual description data, which I only ever want to load into memory once I drill down to a specific record.

However, I must be doing something wrong.  I have this:

DIRECT QUERY

  dimension KEY_FIELD

  detail DESCRIPTION

from SA.TABLE;

But whenever I refresh the report, it seems to want to load 70 million rows into memory.  This seems to defeat the point, as it would take half an hour to run - how do I get this to work without it having to load all of the KEY_FIELDS into memory?

Thanks!

1 Reply
agomes1971
Specialist II
Specialist II

Hi,

put the key fields on a qvd and upload them.

Any doubts we're quite welcome.

André