gnumed-devel
[Top][All Lists]
Advanced

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

Re: [Gnumed-devel] Postgres query / display speed was Re: Release Candid


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Postgres query / display speed was Re: Release Candidate 1.0.rc3
Date: Sat, 24 Sep 2011 14:03:22 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

On Wed, Sep 21, 2011 at 04:53:45PM +0200, Karsten Hilbert wrote:

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

I checked and it didn't.

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



reply via email to

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