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/
> Ok, I have a database with 35 tables in it. I need to index fields
> from each of the tables so that it can all be searched and return the
> record numbers to pull out all the details. But bringing back every
> record with 35 tables joined takes so long things time out. So my
> plan was to query a table, add it to a collection, then do the next
> and add it to the same collection. IOW each query appends to the body
> field of 1 collection with seperate cfindex calls.
>
> However each time I use an index statement, it erases what is curently
> there. Any ideas other them building the body in a variable or file
> and then indexing that?
>
> Thanks
Greg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226492
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
