[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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]