The documentation suggests using low cardinality field(s) for index sorting.
We often search documents with some low cardinality ID (like site or org) and then with timestamp.
Does it make sense to include timestamp in the mix?
I am paying a little bit overhead for the write with "index sorting". If I can't get much out of it, I will remove timestamp to gain back the write performance.
Any suggestions will be highly appreciated.