[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] patient search widget timings

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] patient search widget timings
Date: Fri, 28 Mar 2003 02:35:01 +0100
User-agent: Mutt/

> 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 ?

> 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.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

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