Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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!

Tags (2)
1 Reply
agomes1971
Valued Contributor

Re: Direct Query slow loading

Hi,

put the key fields on a qvd and upload them.

Any doubts we're quite welcome.

André

Community Browser