date sort vs id sort

I am currently using a query simple sorting by ID. That seems to be 100% correlated to the date-time stamp - have not seen any exception.
Is this assumption correct, and what happens if the ID gets larger than 2**64 (probably after my EOL).
thx

Karl

[matt (support)]

From the SQLite docs:

If the largest ROWID is equal to the largest possible integer (9223372036854775807) then the database engine starts picking positive candidate ROWIDs at random until it finds one that is not previously used. If no unused ROWID can be found after a reasonable number of attempts, the insert operation fails with an SQLITE_FULL error.

But based on my math and assuming that 10,000 rows are added every second (higher than Indigo Server could handle), then it wouldn't hit the maximum for 29.2 million years. So even if it didn't try to find unused positive candidates I wouldn't worry about it.

so you mean your company is short lived, using tools that only last 27 M years?

[matt (support)]

Just part of our planned obsolescence strategy to make customers upgrade every 20 or 30 million years.