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

[Karsten Hilbert]

On Wed, Sep 21, 2011 at 11:14:54AM +0200, Karsten Hilbert wrote:

> > the display of my 13,000 brands requires 30 seconds to build
> ...
> 
> > Is the speed (slowness) a reflection of (not) having an index that
> > corresponds to what the GUI is wanting?
> 
> Since we are reading from a view that's joining several tables
> by foreign keys that may be a reason - missing indexes on either
> side of the link. I'll check that.

Not that I think it would matter in this particular case but
we were missing indexe on

        clin.vaccine.id_route
        clin.substance_intake.fk_drug_component

which I have now added.

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