[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] patient search widget timings
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] patient search widget timings |
Date: |
Fri, 28 Mar 2003 10:02:16 +0100 |
User-agent: |
Mutt/1.3.22.1i |
> >>> db = DB.connect(database='gnumed', host='192.168.0.1', user='hherb')
This is over the LAN, I assume.
> >>> def test(n):
> t1 = time.time()
> cur = db.cursor()
> cur.execute("select id, title, firstnames, lastnames from names limit
> %d" % n)
^^^^^
Can you run that once more against v_basic_person ? Any
noticeable difference ?
> >>> def test2(search):
> t1 = time.time()
> cur = db.cursor()
> cur.execute("select id, title, firstnames, lastnames from names where
> %s" % search)
Same here.
> >>> test2(r"lastnames like 'H%'")
> 232 records fetched in 0.060 seconds
> >>> test2(r"lastnames ilike 'a%'")
> 100 records fetched in 0.000 seconds
> >>> test2(r"lastnames ilike 'h%' and firstnames ilike 'a%'")
> 18 records fetched in 0.000 seconds
> >>> test(100)
> 100 records fetched in 0.060 seconds
> >>> test(1000)
> 1000 records fetched in 0.270 seconds
> >>> test(2500)
> 2500 records fetched in 0.500 seconds
> >>> test(2500)
> 2500 records fetched in 0.500 seconds
Looks good. It seems sensible that much of this should depend
more on RAM/disk speed than on CPU power.
> I suspect in your case your server is just swapping to death b/o the
> minimalistic RAM
That's what the server sounds like. It's quite amazing that it
does so 'well' under such circumstances at all ...
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] patient search widget timings, (continued)
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Karsten Hilbert, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, richard terry, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings, Horst Herb, 2003/03/27
- Re: [Gnumed-devel] patient search widget timings,
Karsten Hilbert <=
[Gnumed-devel] Re: patient search widget timings -more comment, richard terry, 2003/03/27