|
From: | Karsten Hilbert |
Subject: | Re: [Gnumed-devel] Postgres query / display speed was Re: Release Candidate 1.0.rc3 |
Date: | Wed, 21 Sep 2011 11:14:54 +0200 |
> 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? An index would have exactly zero impact on reading an entire table. > Is it the nature of the join? 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. Karsten -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone
[Prev in Thread] | Current Thread | [Next in Thread] |