topic Re: Is section access caused a slow data reload in QlikView

Is section access caused a slow data reload

kishorj1982 — Sat, 16 Nov 2024 02:15:45 GMT

Hi,

I have an application that has a number of tables and data size is also huge. It seems after applying the section access document is taking too much time to open in the access point.

My question is in this scenario is section access is the culprit.

Please suggest.

Thanks

Re: Is section access caused a slow data reload

martinpohl — Thu, 10 Oct 2019 11:40:48 GMT

Hi,

I haven't stop the time to compare open time but there should not be a difference.

But have you change the data model with additonal section access fields?

Regards

Re: Is section access caused a slow data reload

kishorj1982 — Thu, 10 Oct 2019 13:49:46 GMT

Hi,

There is no change in the data model.

But we have maintained users in external files and also maintaining reduction columns in the same file.

On top of that, in the section access table in the application, we are reloading those columns.

Thanks

Re: Is section access caused a slow data reload

Brett_Bleess — Mon, 14 Oct 2019 21:40:54 GMT

Koshor, I think the key question is whether you are using dynamic data reduction field(s) in the Section Access table, I could see that potentially taking some time in a huge app to sort out the viewable table structure for the user etc... In this case, if you have Publisher, you may want to look into maybe doing a Loop and Reduce/Distribute instead to break the large app into smaller versions per user or some other smaller unit of which then the Section Access will run more efficiently I would suspect.

Regards,
Brett

Re: Is section access caused a slow data reload

paulyeo11 — Tue, 30 Jun 2020 07:04:23 GMT

Hi Bertt

You seen to know how to solve the problem . I also face the same issue.

https://community.qlik.com/t5/New-to-QlikView/Case-0002-Why-loading-time-increase-3-time-after-add-section/m-p/1723362/highlight/false#M390663

Hope you can take a look of above link.

Paul Yeo