[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] type of search pattern for demographics

From: Ian Haywood
Subject: Re: [Gnumed-devel] type of search pattern for demographics
Date: Sat, 21 Aug 2004 00:49:44 -0400
User-agent: Mutt/1.3.28i

On Fri, Aug 20, 2004 at 09:22:12PM -0700, J Busser wrote:
> this would be immensely helpful to be searched but perhaps it will
> reside in a non-demographic table among other types of health insurance
> numbers and may be less manageable?
No, the demographics server can support arbitrary IDs. 

> Does postgres support index or key files and does gnumed use them?
Postgres does support indexes and they are used liberally in gnumed.
However they are not "files" as such -- postgres is a higher level database
than Foxpro or MS-Access and as users we don't get involved in what is or is 
not a file.

Note all indexes do is accelerate searches at the expense of inserts/updates - 
you can still search by non-indexed columns. 

> Is searching faster by maintaining an index or key of 
> upperCase(surname) and uppercase(givenNames)
Not significant AFAIK

> O"Malley
> 2) spaces
> de Groot
> - would people want the above accounted for?
AFAIK we already do.



Attachment: pgp1o8gXjCoGt.pgp
Description: PGP signature

reply via email to

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