< 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. _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
