Dave Phillips wrote: > > I am now trying to JOIN these two queries using a Query of Queries to > join the SCORES of the original search results to the 'expanded' data > found in the database. My ideal result would be a query with all > expanded data (everything is related as it should be) and the score > from the original process, task, or detail that was found in the > search result related to the right records. So, for example, if the > search criteria was found in a detail, and the score on that was say > 78%, and if that search criteria was used in 4 different tasks that > were each used on two different processes, then I should end up having > 8 rows in my database with the same 78% score.
I think you can do better on that. For instance, you can weigh the results by multiplying hits in the process by 3, hits in the tasks with 2 and hits in the details with 1, then dividing by the total number of tasks and details. > I explained as much as possible just in case someone might think of > another completely different approach to what I'm trying to do. Why not use the full text searching of your database? > Again, > I am trying to avoid storing all 4,000+ records in the index, so, at > this point, that is not an option. Why not? Is the speed difference even significant? Typically searching an index scales with the natural logarithm of the cardinality so 4000 composite records should only be 1.5 times slower then 900 individual records. You will easily loose that much on running a second query and joining that to the cfsearch result. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
