[Gnumed-devel] re: optimization

[Syan Tan]

<                               age(last_affirmed) < %s::interval
---
>                               last_affirmed > now() -  %s::interval


this change makes the query parser use the btree inex of last_affirmed,
otherwise a sort is done for some reason, and for many items (10000+)
increases record retrieval time by a second or more.