I don't have comparisons using the same app. For some apps I've used Verity, and I used SQL7 full text exclusively in www.SMARTERyellowpages.com
I have heard that Verity K2 search is very fast (and uses the same index as Verity vanilla search), but again, I have no comparable data. One thing to check is whether CFSEARCH allows caching (Studio doesn't think it does, which agrees with my recollection). If your app is as amenable to caching queries as www.SMARTERyellowPages.com is, then your choice may be clear. For example, if you go to <http://www.smarteryellowpages.com/hl/index.cfm/al.S> and click on each of the 1 2 3 4 5 6 7 8 result pages, each page request after the first is from a query cached for 5 minutes. Similarly for full text searches. The only way to decide is to try it out on your app. When I first developed SMARTERyellowpages.com, I stored all database data in Structures (in memory, and it took the app about 20 minutes to start up and load the structures). When I compared with cached queries I found that, for my app, cached queries were faster. But this was because my app did not take advantage of the unique capabilities of structures. Other apps that can use structures well will be faster than cached queries. best, paul At 02:49 PM 12/13/02 -0500, you wrote: >Thanks Paul. What has your experience with query speed been between the >two? I've had a few people tell me that Verity might be a bit quicker. > >Thanks again. > >On 12/13/2002 1:21 PM, paul smith <[EMAIL PROTECTED]> wrote: > >SQL7/2000 allows combination of full-text searches and standard SQL > >in the > >same query. > > > >With Verity I find I often need a query to find the list of IDs that > >match > >the search text, and then a second query to match the standard SQL > >constraints. > > > >Not that important if your app is not heavily loaded. > > > >best, paul > > > >At 12:02 PM 12/13/02 -0500, you wrote: > >>Would love to hear people's feelings and relative advantages/disadvantages > > > >>of each.Need to make a decision and I'm vacilating between the two. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
