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