Given a very large amount of external objects, representing for instance
transactions, what would be the quickest way of handling the creation stamp
be with regards to future lookups by way of start stamp and end stamp?
It seems to me that using two relations might be optimal, one +Ref +Date
and an extra +Ref +Time. Then a lookup could first use the +Date relation
to filter out all transactions that weren't created during the specified
days followed by (optionally) a filter by +Time.
Or am I over-thinking it, is a simple +Ref +Number with a UNIX timestamp an
easier approach that is just as fast?
A +Ref +String storing the result of a call to stamp would be ideal as the
information is human readable without conversions. However, I suspect that
a start-end lookup on it would be much slower than the above, or?