Memory problems with 'order by' in upload scripts

Mark94 — Sat, 16 Nov 2024 05:54:08 GMT

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.

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

Lisa_P — Thu, 09 May 2019 00:00:05 GMT

Using the Autonumber function to replace your composite keys may help

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

Mark94 — Thu, 09 May 2019 07:35:24 GMT

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.

topic Re: Memory problems with 'order by' in upload scripts in App Development

Memory problems with 'order by' in upload scripts

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

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