As for optimizing, I would consider doing it daily if you're making several updates and/or refreshes throughout the day. If you're only doing a refresh once a day, then I would optimize once a week or no more than once every other day. I think it would be overkill to optimize every day if you're only refreshing once a day.
Dave -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 12:54 PM To: CF-Talk Subject: Re: CFINDEX - how to add/update a single record in an existing collection? I ended up taking Dave's query for a single record approach because it simplified a number of things. Because of the nature of the app, I update some of the data one column at a time, but it still needs to be indexed immediately. I have a CFC with an updateCollection method that I just pass a collection name and record ID. Followup question. What contributes to the degradation of verity collections? Will updating single records in a collection kill verity search performance? What strategy should I take with repairing/optimizing collections...scheduled task to do it hourly, or would just once a day suffice? Thanks for the help, Pete ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216231 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
