Unfortualy for our purposes it would prob slow things down. We are doing the same with several other databases but can do it in one query with them, they will be updated nightly with a scheduled task. But this one particular one is our achillies heal. Its pulled from a 3rd party product that is an insdustry standard piece of junk :) It uses the "4D" database system to create an almost camilian database system that tries to be all things to all people. We are planning to replace it and provide a competitive product in the next year or two useing Flex 2 and getting it's data from Webservices (which for us will be CF and MSSQL Server). However we have to do this now with what we have. So its kinda a mess.
I was hoping that the cfindex statement could just match the existing record number and append fields in the body param to the exisitng body field. :( *sigh* Thnks though. Greg >Greg, >How about building a Searchable table with the record ID as the primary key >and a text (or blob) field called SearchTerms. Then the first time that this >gets built, just concatenate all the results of the 35 tables together and >dump it into SearchTerms with the RecordID. If you have a lastUpdated field >in your db for that record, next time you want to update the SearchTerms >field, simply run a query that checks to see what records were updated in >(say) the last 24 hours and run the 35-table join only for those records to >update the Searchable table. > >Or is a new table out of the question? > >HTH >George > > > >On 12/7/05, Greg Johnson <[EMAIL PROTECTED]> wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:226483 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
