Re: [Gnumed-devel] postgresql considerations

[Busser, Jim]

On 2012-06-14, at 10:56 AM, Karsten Hilbert 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" ??

-- Jim