[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: |
Wed, 21 Sep 2011 16:53:45 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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
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