[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] |-) timings, again
From: |
Karsten Hilbert |
Subject: |
[Gnumed-devel] |-) timings, again |
Date: |
Fri, 28 Mar 2003 14:00:57 +0100 |
User-agent: |
Mutt/1.3.22.1i |
Apparently I did NOT try my select timings without the
parallel import yet:
- freshly "vacuum analyze"ed database
- restarted postgresql server
- first query run, so, no caching
Running "becker", expecting 207 results, takes 2 seconds to
find the 207 matching IDs and 6 (six) seconds to fetch the
data for those IDs. Quite an improvement, huh ? This is fully
acceptable behaviour particularly for this low-end server.
(Wenn ich den parallelen Import von weiteren Patienten beende,
sinkt die Zugriffszeit für "becker" von 60 auf 6 Sekunden ...)
Karsten Hilbert
--
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] |-) timings, again,
Karsten Hilbert <=