Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gines_rueda
Contributor III
Contributor III

Large Fields in Fact Tables with millions of rows

Hello devs,

I want to ask about the suitability of having very large fields in QlikView e.g, a RTF with 4000 characters. Specially when this fields are inside fact tables with millions of rows showed inside a pivot table. I have noticed that in this case the performance goes down.

Is there a document or guide that cover this? Or maybe a general document explaining that the issues with large datasets are not only with the number of rows but also with the number of fields and the size of them?

The best approach for this that I have thought is to do a document chaining when the rows available go down of a limit.

Any information on this topic will be appreciated.

Thanks.

12 Replies
gines_rueda
Contributor III
Contributor III
Author

Hello Christian

I have done an approach and it works .

This is like my script code:

DIRECT SELECT

ID,

RTF1,

RTF2

FROM

MAIN_TABLE

However there is more possibilities with IMPLICIT FIELDS.

Then I only show this fields in a detailed view. (just 2 select per time to the db).

Thanks for your help.

marcus_sommer

With hyperlink ist meant you could create in a link to any file you want - in your case were each single description saved in an own txt- or pdf-file and only if a user clicked the description will be opened.

- Marcus

gines_rueda
Contributor III
Contributor III
Author

Ok, I will check this approach with my bosses too.

Thanks.