Re: [Gnumed-devel] postgresql considerations

[Karsten Hilbert]

On Thu, Jun 14, 2012 at 06:04:09PM +0000, Jim Busser wrote:

> - many small queries in a use case which would benefit from fewer
>  larger queries
> - one large query in a use case which would benefit from many
>  smaller queries
> 
> I gather that the total amount of information requested can be the same, 
> achieved through two different methods.
> 
> Clearly fetching information that is of no interest can risk to slow things 
> down more than necessary.
> 
> Assuming however in a given case the total amount of information requested 
> was 'just right". is it then a question *not* of whether the case is solved by
> 
> one large query
> vs
> many larger queries
> 
> but rather employing query syntax or methods that are "most efficient" ??

Indeed. That's why I listed both as potential (and likely)
sources of slowness.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346