Re: [Gnumed-devel] Postgres query / display speed was Re: Release Candidate 1.0.rc3

[Karsten Hilbert]

On Wed, Sep 21, 2011 at 04:26:39PM +0200, Karsten Hilbert wrote:

> > Under
> > 
> >     Medications plugin
> >     Add / edit
> >     Brands
> > 
> > the display of my 13,000 brands requires 30 seconds to build (debugging 
> > mode) and 27 seconds (non-debugging).
> 
> I would rather think that the triple application of
> array_agg() when returning the results would contribute the
> most.
> 
> One alternative would be to not pull components into the
> brand view.

Another bit may be that the ref.v_branded_drugs view
cross-checks with clin.substance_intake whether that brand
is currently in use.

Removing that check likely speeds up this view.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346