Direct Query slow loading

Wed, 08 Oct 2014 15:53:15 GMT

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!

Re: Direct Query slow loading

agomes1971 — Fri, 31 Oct 2014 15:52:28 GMT

Hi,

put the key fields on a qvd and upload them.

Any doubts we're quite welcome.

André

topic Direct Query slow loading in QlikView

Direct Query slow loading

Re: Direct Query slow loading