yep, all the stuff I want to use ;-)  grazie mi amico

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 24 July 2003 14:24
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Verity



forgot to mention the ordering results by relevancy, and giving relevancy
scores to those results.  also it can index stuff that's not database
content, e.g. excel, pdf's, text files, html, etc etc.


Duncan Cumming
IT Manager

http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600

Creative solutions in a technical world

----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------


 

                    [EMAIL PROTECTED]

                    sign.co.uk                         To:
<[EMAIL PROTECTED]>                                     
                                                       cc:

                    24/07/2003 14:16                   Subject:     Re: [
cf-dev ] Verity                                        
                    Please respond to dev

 

 





it's good.  if you've got someone searching for something like
fish monkey paste tree

to do this in sql you're going to end up with a nasty query using likes
(especially if you're OR'ing each word!), which is slow.  also might have
to search against multiple fields, e.g WHERE Description LIKE '%
#form.search#%' OR keywords LIKE '%#form.search#%' etc.  verity can do it
all pretty quickly.

also it does the whole stemming thing, where searching for 'fat' will also
get you fatty, fattest, fathead, fatwa, father, etc.  and much more besides


Duncan Cumming
IT Manager

http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600

Creative solutions in a technical world

----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------



                    "Robertson-Ravo, Neil (RX)"

                    <[EMAIL PROTECTED]        To:
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
                    dexpo.com>                          cc:

                                                        Subject:     [
cf-dev ] Verity
                    24/07/2003 13:06

                    Please respond to dev






What are peoples opinion on using Verity instead of standard SQL searches?
Pro's / Con's etc...

ColdFusion 5.0

Ta

N

--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]






--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]






-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to