Re: [Gnumed-devel] Re: low performance

[Karsten Hilbert]

> 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.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346