Using SOUNDEX and CONTAINS

Using SOUNDEX and CONTAINS

Post by Khurram Chaudhar » Mon, 23 Apr 2001 07:09:00



I am trying to use the predicate SOUNDEX with CONTAINS to enhance our
website search. Does anyone know of any good examples I could use?

Khurram

 
 
 

Using SOUNDEX and CONTAINS

Post by Hilary Cotte » Mon, 23 Apr 2001 12:29:50


full text search is not well suited to web based searches.  I suggest you do
some analysis using IDQ, or ixsso, and then full text.  My analysis shows
that FTS is 1000 times slower than IDQ.

MSIDXS supports the contains keyword, it is 3 times as slow as ixsso, which
itself is at least  3 times as slow as IDQ.

Soundex yeilds unpredicatable results.  I suggest you have a look at any
good T-SQL book for examples of its usage. Soundex is only  supported within
SQL.

--
Hilary
www.iisfaq.com

Quote:> I am trying to use the predicate SOUNDEX with CONTAINS to enhance our
> website search. Does anyone know of any good examples I could use?

> Khurram


 
 
 

Using SOUNDEX and CONTAINS

Post by Morten Olse » Tue, 01 May 2001 18:49:04


Hi Hillary

Could you explain, what is behind the abbrevations IDQ and ixsso. Other
DBMSs, other indexing engines? Does it integrate with SQL Server? Any
elaboration, apreciated.

Morten.


> full text search is not well suited to web based searches.  I suggest you
do
> some analysis using IDQ, or ixsso, and then full text.  My analysis shows
> that FTS is 1000 times slower than IDQ.

> MSIDXS supports the contains keyword, it is 3 times as slow as ixsso,
which
> itself is at least  3 times as slow as IDQ.

> Soundex yeilds unpredicatable results.  I suggest you have a look at any
> good T-SQL book for examples of its usage. Soundex is only  supported
within
> SQL.

> --
> Hilary
> www.iisfaq.com


> > I am trying to use the predicate SOUNDEX with CONTAINS to enhance our
> > website search. Does anyone know of any good examples I could use?

> > Khurram

 
 
 

Using SOUNDEX and CONTAINS

Post by Hilary Cotte » Wed, 02 May 2001 11:31:02


IDQ - not sure what this stands for, but it is based on IDC which stands for
Internet Databse Connector - which was the precursor to asp.  IDQ is a dll
that handles Index Server queries.  My guess is that it stands for Internet
data query engine.

ixsso is a com component that allow you to connect to index server natively.
MSIDXS is the ole-db provider for index server.

The original poster wanted to do web based searches - typically this means a
text box that you type in a search phrase and then content that has your
search phrase are returned.  FTS is optimized for database searches on
database content.  It is a good choice when you have to store your data in a
database, and especially when you have to do extensive logic in your query.
Its caching is also much superior to Index Server.

FTS is designed for integration with Site Server and Sharepoint, well
actually Site Server is Index Server with connectors (to Exchange server,
other web sites, and SQL Server).  Sharepoint is the next version of Site
Server.

Index Server does not integrate with SQL Server. Site Server can be made to
crawl a database.  FTS uses Site Server technology to connect to SQL
databases and index them.

Please let me know if you need more info.

--
Hilary
www.iisfaq.com

> Hi Hillary

> Could you explain, what is behind the abbrevations IDQ and ixsso. Other
> DBMSs, other indexing engines? Does it integrate with SQL Server? Any
> elaboration, apreciated.

> Morten.



> > full text search is not well suited to web based searches.  I suggest
you
> do
> > some analysis using IDQ, or ixsso, and then full text.  My analysis
shows
> > that FTS is 1000 times slower than IDQ.

> > MSIDXS supports the contains keyword, it is 3 times as slow as ixsso,
> which
> > itself is at least  3 times as slow as IDQ.

> > Soundex yeilds unpredicatable results.  I suggest you have a look at any
> > good T-SQL book for examples of its usage. Soundex is only  supported
> within
> > SQL.

> > --
> > Hilary
> > www.iisfaq.com


> > > I am trying to use the predicate SOUNDEX with CONTAINS to enhance our
> > > website search. Does anyone know of any good examples I could use?

> > > Khurram

 
 
 

1. pgsql/contrib/soundex (soundex.c soundex.sql.in)


Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/contrib/soundex
     from hub.org:/home/projects/pgsql/tmp/cvs-serv51753/contrib/soundex

Modified Files:
        soundex.c soundex.sql.in

-----------------------------  Log Message  -----------------------------

Revise handling of oldstyle/newstyle functions per recent discussions
in pghackers list.  Support for oldstyle internal functions is gone
(no longer needed, since conversion is complete) and pg_language entry
'internal' now implies newstyle call convention.  pg_language entry
'newC' is gone; both old and newstyle dynamically loaded C functions
are now called language 'C'.  A newstyle function must be identified
by an associated info routine.  See src/backend/utils/fmgr/README.

2. Howto deploy a database with lot of pre-filled data?

3. select soundex(string1), soundex(string2)

4. 7.0 publisher to 6.5 subscriber

5. pgsql/contrib/soundex (soundex.c)

6. Warning! -- SONY SUBSTANDARD SERVICE

7. Using Soundex

8. Contains and Contains table

9. Help w/SQL that contains variables that contain a single quote

10. Using WHERE clause with CONTAINS

11. using CONTAINS in a stored procedure

12. Massive BUG using SQL CE contained in the Everett Beta