Finance | Project Operations, Human Resources, ...

Sorting by RecId

(0) Share

Report

Posted on by SMC

I see lots of code samples that access records in a table while sorting them on recId. I would think CreatedDateTime is a better field to sort on, if enabled.

Is it always guaranteed that every new record in a table receives a record id greater than the previous one?

I have the same question (0)

All responses (2)

Answers (0)

André Arnaud de Cal... 300,824 Super User 2025 Season 2 on at

Like (0)

Report

Hi SMC,

Usually, the record ID is greater for newer records. SQL sequence technology is used. In many cases, there is an index created for the RecId field and not for the CreatedDateTime. Sorting on a non-indexed field is slower compared to retrieving the records in order of an index.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,770 Most Valuable Professional on at

Like (0)

Report

No, it's not guaranteed that the order of record IDs matches the order of creation. For example, you have two AOS servers, both pre-allocate 50 record IDs from the sequence, e.g. 1-50 and 51-100. The second AOS will create records with IDs 51 and 52 and only then the first AOS will create a record with ID 1.

Was this reply helpful? Yes No