I am working on developing search capability for a site that is sort of an online bookmarking tool. So among other things, users are adding links and notes, etc. to a SQL server db via web site driven by coldfusion. I adding the search functionality -- there are 2 needs that are somewhat contradictory (perhaps!). 1) The more advanced matching capabilities of FULLTEXT (proximity etc.) 2) The need to search for items JUST ADDED -- ie., a bookmark that a user may have added only minutes before. All seems well and good implementing FULLTEXT except that if a user needs to find somethign they just added to the db, it will not appear in the results unless the FULLTEXT index has been updated. Some questions: 1) How do people calculate how often a FT index can be updated w/out having an adverse effect on performance (I know, this is hard to answer generally). 2) Is it common and are there good techniques for combing FULLTEXT and regular SQL select queries to combine the best of both worlds... ? HAs anyone combined the 2 successfully? IS this a common approach? Thanks for weighing in... ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
