It has been years since I used Verity, I didn't know you could specify multiple collections. That would certainly be a possiblity. I will have to check into it.
>Don't know if I understand the question correctly, but couldn't you create >35 collections then specify them all in the <CFSEARCH> ? > > I have no idea on the performance hit (if any) of specifying multiple >collections. > > >-----Original Message----- >From: Steve Bryant [mailto:[EMAIL PROTECTED] >Sent: Wednesday, December 07, 2005 3:17 PM >To: CF-Talk >Subject: Re: Verity Help > > >Greg, > >You might consider looking at QueryOfQuery and the UNION operator to get all >of your tables in one recordset. > >If you still have performance problems, you could run the queries on >seperate requests and store them into shared-scope and then run query of >queries against those stored queries once you have them all built (you can >then delete the queries once you have the data indexed). > >Hope that helps! > >Steve Bryant. >Bryant Web Consulting LLC >http://www.BryantWebConsulting.com/ >http://steve.coldfusionjournal.com/ > >Greg ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226542 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
