If the google appliance is runs anything like google does you are going to have restrictions on the number of records you can return as the google API only lets you return 10 records at a time.
If the SQL Full Text search is set up correctly with should be pretty good as it will give you result ranking and all that. Also the SQL way wont restrict you regards to descriptions and stuff as both Verity and Google return a trimmed down description based on what you are indexing. The main advantage of using the Google appliance and Verity is that it can index all your documents like pdfs and that sort of thing which you wont be able to do (as far as i know) using SQL. Food for thought... Steve -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Pat Branley Sent: Wednesday, 19 November 2008 12:11 PM To: cfaussie Subject: [cfaussie] Verity vs SQL Server Full-text index Hi Guys I'm working on a website redevelopment that has a database using SQL server full-text index. Ive never used it before and have always worked with verity. I would be interested to hear about the advantages/ disadvantages of using each. I'm also evaluating google mini and Lucene if you have any thoughts on those too. why im finding it hard to choose is theres no data i can find telling me which is faster or produces more relevant results. My gut tells me verity should be better, but i don't really know for sure. Does anyone know of stats they could point me to ? The other problem is that this will deploy on CF Enterprise servers in a cluster. Cheers Pat --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
