[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 14:35:43 +1100 |
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
- [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, 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 <=
- 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