Hi Les, There are certainly options open to you, and of course your problem is not unique so there is help!
The main issue is that your site was never designed to be searched from the beginning where Search functionality was more of an afterthought. To get the most of your search (I presume you will be using the outdated and feature limited OEM Verity) you should either index the dynamic pages by pointing a spider at your site - but you have to ensure that your links all follow etc. This will give you a good website search. If you index the content from the DB directly into a collection then it's relevancy and potential freshness becomes less and indeed may as well stay in a SQL Full Text Search with you building the front end rather than Verity. A good search engine is a must here if you want to perform "real" searches and utilise things like lemmatisation, synonym addition/conversion etc. But you will pay for these tools and in most cases it will be a lot :-) "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Les Mizzell To: CF-Talk Sent: Sun Nov 12 02:12:25 2006 Subject: Search Questions It's been awhile since I've set up a search engine for a site. The last site I did a search for was a mixed static/dynamic content, which caused a lot of head-scratching. I finally *faked* it by setting a reference table that pretty much included "page_content" and "page_link" columns and just searched that. PITA, it was. I'm now working on a much bigger site with the same problem. Half is static, the rest is coming from maybe 30 different tables in a MySQL database. The site is almost too large for me to try and fake it this time. This is on a shared server, so I don't have access to the cf admin. I can create a Verity collection and index through code, but that's not going to handle some of the dynamic content. What's the most optimal way of handling this search? How do the rest of you handle searches for mixed static/dynamic content? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
