[Top][All Lists]
[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
Re: [Gnumed-devel] Release Candidate 1.0.rc3, Jim Busser, 2011/09/21
- Re: [Gnumed-devel] Release Candidate 1.0.rc3, Karsten Hilbert, 2011/09/21
- Re: [Gnumed-devel] Release Candidate 1.0.rc3, Karsten Hilbert, 2011/09/21
- Re: [Gnumed-devel] Release Candidate 1.0.rc3, Jim Busser, 2011/09/21
- Re: [Gnumed-devel] Release Candidate 1.0.rc3, Karsten Hilbert, 2011/09/21
- Re: [Gnumed-devel] Release Candidate 1.0.rc3, Jim Busser, 2011/09/21
- Re: [Gnumed-devel] Release Candidate 1.0.rc3, Karsten Hilbert, 2011/09/22
Re: [Gnumed-devel] Release Candidate 1.0.rc3, Jim Busser, 2011/09/21