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:260037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
