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?

All responses (2)

Answers (0)

Sort by

André Arnaud de Cal... 307,416 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.
Suggested answer

Martin Dráb 240,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.