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?