Re: [Gnumed-devel] patient search widget timings

[Karsten Hilbert]

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

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346