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

[Karsten Hilbert]

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