[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/1.3.22.1i |
* 207 patients IDs fetched in 0.550 seconds
* patient data fetched in 2.252 seconds
Note:
- same old machine (133 MHz/40 MB)
- same search term ("becker")
But:
- 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 !
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gnumed-devel] ha !,
Karsten Hilbert <=