[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:14:53 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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
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