Re: [Gnumed-devel] patient search widget timings

[richard terry]

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