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]

Reply via email to