Russ, I am probably a bad SQL coder, but almost all the code that I had to do with searching structured databases had about 3 times the amount of CF code interspersed with the SQL queries. Most of the time, my customers want a single search box which can take all kinds of searches. When they enter a phrase, then I have to capture the fact that it is a phrase and conduct the query one way. Now since they want some result, if not for the phrase alone but its constituents, then I have to separate that out and conduct a different search. The CONTAINS query in SQL does a lot, especially in terms of focussed results. But when it does not work for us when we want any old result that remotely has to do anything with the entered search term. I might be talking through my hat here, but I searched long and hard for answers to my problems with full-text search in SQL Server. A simple statistic (albeit anecdotal): When I was working with SQL Server FTS, I was fine-tuning a search for a client who called about once every 2 days about some result that she wanted that wasn't being captured by the query when she entered the search term. Then I would scramble around the code (both SQL and CFML) trying to make sure that everything would not break and at the same time, I could accomodate this request. After about 2 months of this, I switched to Lucene and now? Not a peep out of her! Granted there were some things I did better the second time round, but I was happy, and so was she.
George On 10/2/05, Snake <[EMAIL PROTECTED]> wrote: > > What sor tof problems. > I have used FULL-TEXT SEARCH many times without problem, even on a massive > 13gb database with millions of records, it certainly never required the > user > to do anything special, they just entered their search query in the form > as > uusal. > > russ > > -----Original Message----- > From: George Abraham [mailto:[EMAIL PROTECTED] > Sent: 01 October 2005 14:25 > To: CF-Talk > Subject: Re: SQL Server 2000 Full-text search issues > > Hi, > Full-text search on SQL Server 2K gave me huge problems. Not only was the > code to conduct a full-text search cumbersome, but the user had to learn > how > to define searches in ways that were not really fair to the user. That is > why I decided to turn to another appliance for full-text search structured > databases. At first I tried using the Verity search already packaged with > CFMX. However I soon ran into scaling issues in terms of the number of > records that Verity will store. Since one of my dbs stores more than 100K > records, that alone would take up the limits of Verity's licence. Buying > an > unlimited (or whatever) licence for Verity was a bazillion dollars. > Similar > problems with buying a Google search appliance. We decided to go with > Lucene > from the Jakarta project which is a simply beautiful product. And it is > free. Of course you have to learn Java, but the Lucene email lists are > extremely helpful. Besides Aaron Johnson has some code over at ( > > http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_cold > fusion.html) > that even talks about CF and Lucene. > > I know this doesn't solve your current problem, but I ran into issues with > SQL server like you did and some of them were having our customers (and I, > to some extent) tear their hair out. > > If you need some help with CF and Lucene, I can list some resources or > email > me offlist. > > George > > > On 9/30/05, Martin Parry <[EMAIL PROTECTED]> wrote: > > > > I too get this on my 2003 cluster. I restored the database as a backup > > from my dev box (which it works on) and do a full rebuild - It takes > > but a second to say its complete and then gives me absolutely no > results. > > > > If I find a solution I'll post it here. IF! > > > > Martin Parry > > http://www.beetrootstreet.com > > > > -----Original Message----- > > From: Burns, John D [mailto:[EMAIL PROTECTED] > > Sent: 30 September 2005 16:22 > > To: CF-Talk > > Subject: SOT: SQL Server 2000 Full-text search issues > > > > I have a development CF server (Windows 2003 Server, SQL Server 2000 > > SP4, CFMX 6.1) on which I have a database that has full-text enabled > > on a table. When I run a query against the full-text index, it returns > > 31 rows. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219870 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
