I'm implementing a Verity search for the first time on an internal application. All of our data is in the database, so I'll be creating a collection from a query result set. Before I dive in, though, I want to have my strategy clear in my mind so that the search works effectively and keeps new and updated content efficiently indexed.
As I see it, there are three aspects to a verity search: creating a collection, indexing a collection, and searching that collection. My first question is how to determine if a collection exists. There doesn't seem to be any sort of collectionExists() function; I would prefer to create the collection from within the application so that when it's deployed to a new server I won't have a ton of stuff to worry about creating in CF Administrator. Is the best approach to simply put each collection in a try/catch block so that if the colleciton already exists it won't bomb the application? My second question is what sort of indexing strategies do people use? Take the following scenario: a collection is created, then it is indexed. Later, a record in the database is updated that would change the results for a given query. Am I correct in assuming that the new term wouldn't be returned in a search until after that collection is indexed? If so, is there a way to "update" a single record in the collection, or would the entire collection need to be reindexed? If the entire collection needs to be reindexed, I would assume that there are three options: immediate reindexing when a database record is updated, indexing as a scheduled task (I would assume every 5-15 minutes to be a good time interval), or indexing manually. I'm not dealing with a huge record set, just 10-15k records or so, and the content within those records isn't that big. Finally, the types of searches. My users aren't that advanced, they'll be doing text searches with simple booleans and perhaps a wildcard. Will using the "simple" search type be sufficient? Is there any performance advantage of one search type over another? Also, if there are any good CF-Verity resources available on the web (other than the LiveDocs), I'd appreciate a link. Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208960 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
