[Top][All Lists]

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

Re: [Gnumed-devel] Re: low performance

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Re: low performance
Date: Mon, 14 Jun 2004 12:26:34 +0200
User-agent: Mutt/

> 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)
I am not at all opposed to using views.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

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