Re: [Gnumed-devel] re: Low performance and ethereal

[Horst Herb]

On Tue, 08 Jun 2004 02:36, Karsten Hilbert wrote:
> > for. If we wrote some large denormalizing sql views,
> > maybe  can reduce this by a factor of 10.
>
> That doesn't depend on views being there or not. One could
> just as well send the view definition as the query with the
> same net result...

Not quite in terms of response time, since you give the query analyzer a lot 
more to chew on, but in terms of network traffic, yes

In any case: the vast majority of queries should return in a fraction of a 
second. Initial loading of a patient's data into the GUI should never take 
more than 5 seconds as a hard limit. Else, who would use gnumed?

Make it workable now and optimize later is only adequate as long as we are not 
more than an order of magnitude away from desired performance; in any other 
case it is a serious design problem which is unlikely to improve by mere 
optimizing tweaks.

Horst