[Top][All Lists]

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

[Gnumed-devel] ha !

From: Karsten Hilbert
Subject: [Gnumed-devel] ha !
Date: Tue, 1 Apr 2003 01:02:51 +0200
User-agent: Mutt/

* 207 patients IDs fetched in 0.550 seconds
* patient data fetched in 2.252 seconds

- same old machine (133 MHz/40 MB)
- same search term ("becker")

- make view v_basic_person use indices on BOTH names and
  identity correctly
- optimize queries to actually use indices in the most common
  cases for search terms (i.e. try smart case-sensitive first)
- no parallel import either, but that did not consistently
  have a large influence - it much depended on the actual
  swap state/IO contention of the machine

Now, THIS is where we want to be !

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]