Re: [Gnumed-devel] Re: low performance

[Horst Herb]

On Tue, 08 Jun 2004 22:41, Karsten Hilbert wrote:
> > see http://hherb.com/cgi-bin/twiki/view/Gnumed/PerformanceDesign
>
> using a view *will* cut down on network traffic a bit (for
> the request, anyways). It is unlikely to matter much, though.

Take a person's details plus address:
You can either
- run 5 or more separate queries
- send one rather complex query which will cause a lot of processing for the 
query analyzer, every time
- use a view

If it is not on localhost, a view in such situations can perform an order of 
magnitude better than the worst choice (the five or more separate queries)

Horst