It will be more efficient to narrow the set of keys to evaluate than look at
all of them and evaluate the timestamp.
From: Dickson, Matt MR [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2013 7:12 PM
To: '[EMAIL PROTECTED]'
Subject: TimestampFilter Performance [SEC=UNOFFICIAL]
Is the TimestampFilter an efficient means of filtering results by time
ranges? I have the option of extending the existing rowid's, currently
pre-fixed with yyyymmdd, to include hhmm also, or make use of the
TimestampFilter. In a quick google search someone mentioned that the
TimestampFilter was inefficient is this correct?