Re: Help Optimizing a multi-word search

2002-02-27 Thread Steve Rapaport
On Wednesday 27 February 2002 07:47 am, Jeff Kilbride wrote: > - > I'm going to be implementing a keyword search pretty soon myself, so I'd > like to see you solve this. :) Me too! :-) > What about doing some sort of prefix indexing, instead of indexing the > e

Help! Optimizing a multi-word search

2002-02-27 Thread Steve Rapaport
Problem: 1. in a phone book, a single field may contain several words, e.g. District 52 Police Station. 2. The query for this record may contain some or all of these words, but not necessarily in that order, e.g. Police district 52. 3. Searching for all of the query words can be done in many way

Re: Help Optimizing a multi-word search

2002-02-26 Thread Jeff Kilbride
t;Steve Rapaport" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 4:56 PM Subject: Help Optimizing a multi-word search > > Problem: > 1. in a phone book, a single field may contain several words, e.g. > District 52 Police Station. > 2.

Help Optimizing a multi-word search

2002-02-26 Thread Steve Rapaport
Problem: 1. in a phone book, a single field may contain several words, e.g. District 52 Police Station. 2. The query for this record may contain some or all of these words, but not necessarily in that order, e.g. Police district 52. 3. Searching for all of the query words can be done in many w