[haiku-3rdparty-dev] Re: Fetching data from queries

  • From: Rene Gollent <anevilyak@xxxxxxxxx>
  • To: haiku-3rdparty-dev@xxxxxxxxxxxxx
  • Date: Wed, 4 Nov 2009 20:46:59 -0600

On Wed, Nov 4, 2009 at 8:39 PM, Rene Gollent <anevilyak@xxxxxxxxx> wrote:
> far more than the 4 entries in your folder. The other problem is that
> last_modified is not relative, it's a timestamp, which is to say you
> probably want something like "(%now% - last_modified) < 10000000" as

On second thought, you might want to rework that as "last_modified >
(%now% - 10000000)"..I'm not sure how intelligent BFS is at optimizing
queries, and in case it doesn't do any such thing this form should be
friendlier for the indices.

Regards,

Rene

Other related posts: