[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Re: low performance

From: Horst Herb
Subject: Re: [Gnumed-devel] Re: low performance
Date: Wed, 9 Jun 2004 09:19:54 +1000
User-agent: KMail/1.5.9

On Tue, 08 Jun 2004 22:41, Karsten Hilbert wrote:
> > see
> 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)


reply via email to

[Prev in Thread] Current Thread [Next in Thread]