Re: [Gnumed-devel] patient search widget timings

[Karsten Hilbert]

Richard,

thanks !  Some commentary:

> I tried the same thing in my vb client. 
Do you have 35 000 patients (and counting) in your
database ?

> It gets its data via my 100MB network from Win4lin to the e-smith linux 
> server running on an old Pentium 350. It takes a little over 1 second to 
> retrieve an entire patient record  including the summary screen. 
Ah, I didn't even go so far since I don't have such data yet.

What my code does is:

1) find all the IDs matching the search term that I typed
2) get 'id, lastnames, firstnames, dob' for all those IDs

I added indices on some fields which helps.

Part 1) takes about 1-2 seconds regardless of search term
specifity (unless I type something that returns thousands of
matches).

Part 2) takes anywhere from 1 - infinite amounts of seconds
depending on the number of patients. 207 patients take about
60 seconds. I am not satisfied with that.

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