[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] coding systems
|
From: |
Karsten Hilbert |
|
Subject: |
Re: [Gnumed-devel] coding systems |
|
Date: |
Sat, 17 Sep 2005 19:26:09 +0200 |
|
User-agent: |
Mutt/1.5.9i |
On Thu, Sep 15, 2005 at 09:45:33PM +0000, Horst Herb wrote:
> > select
> > *
> > (select count(term) from clin_narrative where doctor=x and soap_cat='s')
> > as rank from codes
> > where ...
>
> This will perform rather poorly in larger databases and if used frequently in
> the user interface.
Indeed, count(something) *is* likely to incur a significant cost.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346