Memory problems with 'order by' in upload scripts

[Mark94]

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.

[Lisa_P]

Using the Autonumber function to replace your composite keys may help

[Mark94]

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.