[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] patient search widget timings
From: |
richard terry |
Subject: |
Re: [Gnumed-devel] patient search widget timings |
Date: |
Fri, 28 Mar 2003 11:01:45 +1100 |
On Friday 28 March 2003 9:34 am, you wrote:
> Richard,
>
> thanks ! Some commentary:
> > I tried the same thing in my vb client.
>
> Do you have 35 000 patients (and counting) in your
> database ?
NOPE, probably 5000 +
>
> > It gets its data via my 100MB network from Win4lin to the e-smith linux
> > server running on an old Pentium 350. It takes a little over 1 second to
> > retrieve an entire patient record including the summary screen.
>
> Ah, I didn't even go so far since I don't have such data yet.
>
> What my code does is:
>
> 1) find all the IDs matching the search term that I typed
> 2) get 'id, lastnames, firstnames, dob' for all those IDs
As a matter of interest are you just searching first on firstname, surname,
or do you include code to try and match DOB etc as well (I would think this
would slow things down??)
>
> I added indices on some fields which helps.
>
> Part 1) takes about 1-2 seconds regardless of search term
> specifity (unless I type something that returns thousands of
> matches).
>
> Part 2) takes anywhere from 1 - infinite amounts of seconds
> depending on the number of patients. 207 patients take about
> 60 seconds. I am not satisfied with that.
>
> Karsten
- [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 <=
- 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, 2003/03/28
[Gnumed-devel] Re: patient search widget timings -more comment, richard terry, 2003/03/27