[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.
- [Gnumed-devel] re: optimization,
Syan Tan <=