Dominic, thanks for your tip. It looks interesting... So you basically perform a full-text search using Verity, and search for other 'filters' using db, and then filter the db-based search to return only results matched by Verity search, avoiding the IN () comparison. Did I get that right? That looks like the solution for me, as I will have to return a lot more data about each photo that a Verity collection can index...
I have tried using Categories in a collection, and though categories are supported for db query-based collection, they do not work the way I though they would... Short of creating a separate collection for each possible facet-category-keyword combination, I can't achieve what I wanted with them... I thought having my b query group the records by, say, facet, and then having all facets listed as categories in the collection would 'sort' the collection by facets, but instead all the photos were assigned all the categories in the collection... If your approach really outperforms the basic recommended IN () filtering, that's the way forward i guess! Thanks for your input! Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dominic Watson wrote: > I second that. I have just done something similar although I found that when > lots of results were returned by the verity search, something like this far > out performed using an 'IN (keyList)' statement (even when the second query > returned a huge number of results): > > > <cfsearch collection="theCollection" criteria="#search#" type="simple" name= > "qVerityResults"> > > <cfquery name="qDBFilterResults" datasource="#theDatasource#"> > *SELECT* * *FROM* tableX *WHERE* filters = #theFilters# <!--- yes, > cfqueryparam - could be many filters here ---> > </cfquery> > > <cfquery name="qFinalResultSet" dbtype="query" maxrows="#maxRows#"> > *SELECT* qVerityResults.*, qDBFilterResults.* > *FROM* qVerityResults, qDBFilterResults > *WHERE* qVerityResults.*key* = qDBFilterResults.tableXId > </cfquery> > HTH > > Dominic > > > On 02/04/2008, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > >> I use Verity often (including in an education-oriented document management >> project that I'm working on), but have avoided categories...probably >> because >> of the lack of good documentation on their use. >> >> What I do is index documents with Verity, and have the [key] be the PK in >> a >> documents table in my database. I will then create any other tables that >> I >> need to further describe or categorize the data and use that to "refine" >> my >> verity search by excluding records as needed with an in/not in statement >> in >> my SQL. That's a very, very boiled down description of the approach I >> take, >> there does tend to be a lot more going on... >> >> Pete >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
