Verity or a classic search?
Hi guys, I looking for some advice. I have a DB with a table book which contains a field keywords. This field will be fill in with word separated by comma like (IT, Computer, Coldfusion, CFML, Web). This field can be updated and key words can be added or deleted. The user will use an UI with a search form where the search criterias could be: author, title and keywords for instance.The keywordfield will be a multiple select menu. My question is to know which one will be the faster to process for the application. A verity collection or a classic SQL query which will contain the specific keywords? Thanks, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Verity or a classic search?
i'd stick with verity myself because you could use various search tools/processing techniques like soundex, etc. [EMAIL PROTECTED] 9/10/2004 8:12:25 AM Hi guys, I looking for some advice. I have a DB with a table book which contains a field keywords. This field will be fill in with word separated by comma like (IT, Computer, Coldfusion, CFML, Web). This field can be updated and key words can be added or deleted. The user will use an UI with a search form where the search criterias could be: author, title and keywords for instance.The keywordfield will be a multiple select menu. My question is to know which one will be the faster to process for the application. A verity collection or a classic SQL query which will contain the specific keywords? Thanks, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Verity or a classic search?
Personally I would use a verity search as you get a summary and score returned so you can create a results output similar to Google which most people are now fimilar with. Andrew. - Original Message - From: Jean Marc Bottin [EMAIL PROTECTED] Date: Fri, 10 Sep 2004 17:12:25 +0200 Subject: Verity or a classic search? To: CF-Talk [EMAIL PROTECTED] Hi guys, I looking for some advice. I have a DB with a table book which contains a field keywords. This field will be fill in with word separated by comma like (IT, Computer, Coldfusion, CFML, Web). This field can be updated and key words can be added or deleted. The user will use an UI with a search form where the search criterias could be: author, title and keywords for instance.The keywordfield will be a multiple select menu. My question is to know which one will be the faster to process for the application. A verity collection or a classic SQL query which will contain the specific keywords? Thanks, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Verity or a classic search?
go with verity.Which will be faster?Probably depends on volume of data really.Which is more robust out of the box? Verity. Doug - Original Message - From: Andrew Dixon [EMAIL PROTECTED] Date: Fri, 10 Sep 2004 16:23:07 +0100 Subject: Re: Verity or a classic search? To: CF-Talk [EMAIL PROTECTED] Personally I would use a verity search as you get a summary and score returned so you can create a results output similar to Google which most people are now fimilar with. Andrew. - Original Message - From: Jean Marc Bottin [EMAIL PROTECTED] Date: Fri, 10 Sep 2004 17:12:25 +0200 Subject: Verity or a classic search? To: CF-Talk [EMAIL PROTECTED] Hi guys, I looking for some advice. I have a DB with a table book which contains a field keywords. This field will be fill in with word separated by comma like (IT, Computer, Coldfusion, CFML, Web). This field can be updated and key words can be added or deleted. The user will use an UI with a search form where the search criterias could be: author, title and keywords for instance.The keywordfield will be a multiple select menu. My question is to know which one will be the faster to process for the application. A verity collection or a classic SQL query which will contain the specific keywords? Thanks, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Verity or a classic search?
Thanks for your advice, guys. Jean-Marc Douglas Knudsen wrote: go with verity.Which will be faster?Probably depends on volume of data really.Which is more robust out of the box? Verity. Doug - Original Message - From: Andrew Dixon [EMAIL PROTECTED] Date: Fri, 10 Sep 2004 16:23:07 +0100 Subject: Re: Verity or a classic search? To: CF-Talk [EMAIL PROTECTED] Personally I would use a verity search as you get a summary and score returned so you can create a results output similar to Google which most people are now fimilar with. Andrew. - Original Message - From: Jean Marc Bottin [EMAIL PROTECTED] Date: Fri, 10 Sep 2004 17:12:25 +0200 Subject: Verity or a classic search? To: CF-Talk [EMAIL PROTECTED] Hi guys, I looking for some advice. I have a DB with a table book which contains a field keywords. This field will be fill in with word separated by comma like (IT, Computer, Coldfusion, CFML, Web). This field can be updated and key words can be added or deleted. The user will use an UI with a search form where the search criterias could be: author, title and keywords for instance.The keywordfield will be a multiple select menu. My question is to know which one will be the faster to process for the application. A verity collection or a classic SQL query which will contain the specific keywords? Thanks, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]