[Top][All Lists]

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

[Gnumed-devel] patient search widget timings

From: Karsten Hilbert
Subject: [Gnumed-devel] patient search widget timings
Date: Thu, 27 Mar 2003 16:28:21 +0100
User-agent: Mutt/

I have done a few timings on the search widget.

When I type "becker" I am expecting 207 patients to be
identified as matching. It takes

- 1.77 seconds to download the 207 matching IDs
- 70.5 seconds to download more patient data for display in
  the patient selection list (id, last name, first name, dob)

When I type "hilbert" I am expecting 2 patients:

- 1.82 seconds to download IDs
- 4.5 seconds to download more data

When I type "hilbert,k" I expect 1 patient:
- 1.66 seconds ID retrieval
- 1 second until the patient is in the widget (no list)


This is not where we want to be but I would say it is fairly
reasonable given the test environment below. I will time the
same queries with the commercial EMR from which I borrowed the
patient records once I get back to work. For the time being
the code can go in I'd say.


test environment
 - Pentium 133 MHz
 - 40 MB RAM
 - 300 MB Swap
 - (quite) old SCSI drive
 - CPU load around 95%

 - 7.1
 - shared buffers set to 512
 - accessed over 10 MBit/s LAN
 - 22 000 patients in database
 - fetch will return lists, not dicts
 - indexed
 - data download queries running with WHERE id = ..
 - queries running against view v_basic_person

 - concurrently importing more patients (80 000 to go)
 - no other significant server load

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]