[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] coding systems
|
From: |
Horst Herb |
|
Subject: |
Re: [Gnumed-devel] coding systems |
|
Date: |
Thu, 15 Sep 2005 21:45:33 +0000 |
|
User-agent: |
KMail/1.7.2 |
On Wed, 14 Sep 2005 15:32, Karsten Hilbert 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.
Strongly suggest to use a single per-user "stats" table instead
Horst