Re: [Gnumed-devel] patient search widget timings

[Karsten Hilbert]

> >>> 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