I've never used Solr before. About ten years ago I worked on a Monster.com competitor that never really "got there." One of the things we did was make use of cf's verity collections for resume and job searching. It worked really well but we found it somewhat cumbersome updating the collections. It also proved to be less than portable when we moved servers. I do wonder now though, with the resources available to db servers now, if a well indexed db would really perform significantly slower. Ten years ago it was almost a given that a collection was faster, but I wonder now if that still holds true.
On Tue, Feb 8, 2011 at 8:22 PM, Dave Watts <[email protected]> wrote: > > > As a purely academic question I'd be interested in knowing your reasons > to > > use verity (or whatever cf uses now) instead of the database directly. > > CF allows you to use either Verity or Solr. In general, people use > these instead of database queries to improve performance when > searching for substrings of text. But in the original poster's case, > he might be better served by your suggestion instead of mine. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
