gnumed-devel
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]