I agree... using SQL 'CONTAINS' on full-text indexed database fields has
always been a much better search method for doing database searches, in my
experience.
~Simon
> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 22, 2000 12:57 PM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: Re: MS Index Server vs. Verity
Index Server is included in SQL Server 7.
For my application, I like SQL7 full-text indexing and searching on
database fields better than Verity, having directly compared their
performance in the same application. I don't use stemming though (and,
like Google, don't want to). For my application, SQL full-text is
decidedly faster. As always, YMMV.
best, paul
At 08:45 AM 11/22/00 -0800, you wrote:
>I had to demo how cold fusion works to my I.S. department last week and
>after showing them how 'verity' works they suggested I look into 'Index
>Server' as a 'better' alternative. Can I get some of your opinions as to
the
>differences between the two and where I can get more info on 'Index Server'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists