Re: [Gnumed-devel] patient search widget timings

[richard terry]

On Friday 28 March 2003 1:56 pm, you wrote:
> >> How long *does* it take to bring up a list of 200 patients ?
> >
> > Entering * or *,* takes approx 1.5 seconds to bring up list box of
> > 5,500+patients ordered by surname inc name surname, dob, address, suburb.
> > This is  MS2.0 table from Pracsoft, linked to my Access7.0 database.
>
> Darn it ! :-)   But thanks anyways.  Is the database running
> on the same machine as the program you are using to send the
> query ?

No, the database(s) ie pracsoft.mdb and medrec.mdb live on the e-smith linux 
server.

> > Interestingly if I do the query from within Access7.0 it is instantaneous
> > so I couldn't measure the time.
>
> It may have been cached from the previous query.

Not so, It was a clean query, and I just re-did it opened access again, 
re-designed the query and run it - same result.

>
> I am fairly sure now that the poor server is plain overloaded.
> I am now at 40 000 patients and when I run the 207 matches
> query from psql directly on the server I get the same results
> with heavy swapping going on (the import script is still
> running in the background). So it's not the transfer over the
> LAN link.
>
> Karsten