Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Partner
Partner

Memory problems with 'order by' in upload scripts

Hi everyone,

I have a problem with record order in some app in my data model. After some data upload in a new version of an app I see that new app's memory change with differrents records orders in the app's linktable (linktable contains every key that I have in the tables of this app). I try to upload the same linktable in different version of this app and after some tests I find the problem. The memory gap between these different version of the same app is due to a different order by put in the record of linktable at the moment of linktable upload in these app.

Anyone know if there are any rules that determines what is the best way to order records in a table for econimize memory in app? Or some of you have a response or any idea about?

Thank you so much.

Labels (2)
2 Replies
Highlighted
Employee
Employee

Re: Memory problems with 'order by' in upload scripts

Using the Autonumber function to replace your composite keys may help
Highlighted
Partner
Partner

Re: Memory problems with 'order by' in upload scripts

Thank you but we have already used Autonumber and we saw that app memory changes basing on diffent fields using for the 'order by' function, it's a very strange thing.