[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:26:39 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Tue, Sep 20, 2011 at 06:02:28PM -0700, Jim Busser 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.
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