[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] patient search widget timings
From: |
richard terry |
Subject: |
Re: [Gnumed-devel] patient search widget timings |
Date: |
Fri, 28 Mar 2003 13:30:51 +1100 |
On Friday 28 March 2003 12:35 pm, you wrote:
> > It's interesting that it is so slow just to return a straight list of
> > fields like name, surname, dob etc.
>
> How long *does* it take to bring up a list of 200 patients ?
Entering * or *,* takes approx 1.5 seconds to bring up list box of
5,500+patients ordered by surname inc name surname, dob, address, suburb.
This is MS2.0 table from Pracsoft, linked to my Access7.0 database.
Interestingly if I do the query from within Access7.0 it is instantaneous so
I couldn't measure the time.
>
> > When I display my stuff the pop up box comes up
> > with name, surname, street, suburb cause in general practice that's how
> > we recognise which 'john brown' we need from the list.
>
> That's really easy to change, just modify one query in one
> place. Once in the list one can always press TAB on any listed
> patient and get more comprehensive info (insurance agency,
> last visit, address, etc. -- not implemented yet, however).
>
> > DOB I guess more
> > applicable and should be included, is there something about that field
> > which is causing problems?
>
> Not that I can think of. I am doing some formatting on it,
> though, (to_char(dob, 'format string')) which will have some
> impact. Will play around with that a little more. I'd be
> surprised, however, if that's the only reason.
>
> The same query takes just as long when run from the pgsql
> command line utility if that's any consolation. So, it's not
> our general framework but rather either the query, the LAN
> link or the backend itself.
>
> Karsten
- [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings,
richard terry <=
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Horst Herb, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/28
[Gnumed-devel] Re: patient search widget timings -more comment, richard terry, 2003/03/27