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

[Karsten Hilbert]

On Mon, Jun 02, 2014 at 10:48:24PM +0000, Jim Busser wrote:

> My org unit table has more than 10,000 records because of my having loaded it 
> with the addresses of all doctors in my province.
> 
> Could this be the reason why, when I try tabbing through the encounter GUI 
> field for location, I get a pause that costs me several seconds

Could you post the output of the following queries ?


        EXPLAIN SELECT
                pk_praxis_branch AS data,
                branch || ' (' || praxis || ')' AS field_label,
                branch || coalesce(' (' || l10n_unit_category || ')', '') || ' 
of ' || l10n_organization_category || ' "' || praxis || '"' AS list_label
        FROM
                dem.v_praxis_branches
        WHERE
                branch ILIKE '%abc%'
                        OR
                praxis ILIKE '%abc%'
                        OR
                l10n_unit_category ILIKE '%abc%'
        ORDER BY
                list_label
        LIMIT 50
        ;

        EXPLAIN SELECT
                pk_praxis_branch AS data,
                branch || ' (' || praxis || ')' AS field_label,
                branch || coalesce(' (' || l10n_unit_category || ')', '') || ' 
of ' || l10n_organization_category || ' "' || praxis || '"' AS list_label
        FROM
                dem.v_praxis_branches
        WHERE
                branch ~* '( abc)|(^abc)'
                        OR
                praxis ~* '( abc)|(^abc)'
                        OR
                l10n_unit_category ~* '( abc)|(^abc)'
        ORDER BY
                list_label
        LIMIT 50
        ;


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