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