[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] re: optimization

From: Syan Tan
Subject: [Gnumed-devel] re: optimization
Date: Fri, 10 Mar 2006 12:32:14 +0800

<                               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.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]