Re: [Gnumed-devel] Praxis encounter location slow to populate

[Karsten Hilbert]

On Thu, Jun 05, 2014 at 05:48:29PM +0000, Jim Busser wrote:

> On running the script, my terminal showed the appended.
> 
> Should the changes be immediately active?
> 
> I ask because the output of the queries looks unimproved … maybe postgres is 
> failing to take advantage of the index?

Maybe so, perhaps because the LEFT JOIN constrains the
planner more than an INNER JOIN would. Since semantically an
INNER JOIN will do just what is needed I have modified the
relevant views to use that (along with taking out a subquery
not necessary for the v_praxis_branches view.

Please run the attached files against your database (first
the *org* one, then the *branch* one) and re-report the
results of the queries we used to analyze query execution.

Those changes will, again, be part of the next bugfix release.

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

v19-dem-v_orgs_v_org_units-fixup.sql
Description: application/sql

v19-dem-v_praxis_branches-fixup.sql
Description: application/sql