[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Postgres query / display speed was Re: Release Candid
Re: [Gnumed-devel] Postgres query / display speed was Re: Release Candidate 1.0.rc3
Wed, 21 Sep 2011 17:14:29 +0200
On Wed, Sep 21, 2011 at 05:06:59PM +0200, Karsten Hilbert wrote:
> > Doing an instring search on a single letter producing 8000 results * 60
> > fields
> > each took about 4 seconds, but doing an instring search on 3 letters like
> > '%amo%' took <100msec, once you've typed eg amoxi takes <30msec. And all
> > that
> > without anything more than a primary key, no other indexes on any of the
> > table
> > fields.
> > Hence presuming your search routines using a delay timer which only flicks
> > off
> > the query to the server once the user stops typing
> Which is exactly what we do in the phrasewheels - this being
> due to what Richard suggested doing many moons ago.
And doing an instring search on "cital 10" from within the complex
phrasewheel proved instantaneous, indeed, showing 7 brands
containing 10mg of citalopram.
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
Re: [Gnumed-devel] Release Candidate 1.0.rc3, Jim Busser, 2011/09/21