topic Re: Extensions slow performance with huge data set in QlikView

Extensions slow performance with huge data set

Mon, 26 Jan 2026 16:26:21 GMT

I've created a tree view extension in qV11 but it takes lot of time to load the data and render while table view with the same data set works fast . Can somebody explain the data loading and filtering process for extensions and how is it different from table view ? How can we achieve faster data loading with extensions ?

Re: Extensions slow performance with huge data set

rwunderlich — Wed, 08 Apr 2015 22:20:28 GMT

A significant difference is that for QV objects the data remains on the server, and only visible data is transferred to the client. In an extension, any data required by the extension is transferred to the client to act upon.

-Rob

Re: Extensions slow performance with huge data set

Wed, 08 Apr 2015 22:29:41 GMT

Thanks Rob for your response.Do you have any suggestion to enhance the performance while working with extensions? Is there a way to have some pagination kind of stuffs which will load only part of the data at a time?

Re: Extensions slow performance with huge data set

rwunderlich — Wed, 08 Apr 2015 22:48:33 GMT

I don't have any specific advice in this area, although other may. Have you looked at qlik.branch.com for something similar to what you are doing

-Rob

Re: Extensions slow performance with huge data set

Wed, 08 Apr 2015 23:08:57 GMT

No, I still haven't explored branch. Will try to see if I can get something similar there .Thank you.

Re: Extensions slow performance with huge data set

Alexander_Thor — Thu, 09 Apr 2015 19:00:18 GMT

Yes, in the definition.xml file (or via script) you set a PageHeight property.
This define how "high" or how many rows per page of data you receive. The higher the value the more rows the server has to send to the client.

Our standard table object for example will load data incrementally as you scroll through the data.
How a look at the documentation for the PageObject JsDoc Reference - Qv.Document.Object.Data.PageObject

Re: Extensions slow performance with huge data set

Alexander_Thor — Thu, 09 Apr 2015 19:02:07 GMT

This is a also a sample on how to achieve paging in the UI

Re: Extensions slow performance with huge data set

Thu, 09 Apr 2015 19:09:00 GMT

Thanks Alexander..it should be really helpful .Will try this out . Actually I need to implement pagination for the D3 Collapsible tree view. Where, I want initially to show only 10 children for a particular node with a link which will display the other nodes in the size of 10 .

-Kunal

Re: Extensions slow performance with huge data set

Alexander_Thor — Thu, 09 Apr 2015 19:11:41 GMT

Hmm, that might be a bit harder as you can't really query a sub-set like that.
But if it's a fixed multiplier of 10 I guess you could match the initial page height with nodes X 10

Re: Extensions slow performance with huge data set

Thu, 09 Apr 2015 19:14:06 GMT

Yes, that's what I was also thinking.