Re: [Gnumed-devel] re: optimization

[Karsten Hilbert]

On Fri, Mar 10, 2006 at 12:32:14PM +0800, Syan Tan wrote:
> X-Mailer: AtMail 4.3
> Subject: [Gnumed-devel] re: optimization
> 
> 
> 
> <                             age(last_affirmed) < %s::interval
> 
> ---
> 
> >                             last_affirmed > now() -  %s::interval
Exactly where is this change needed ? I'd like to add it.

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

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346