>I have experienced this with collections that are built up incrementally >over time, where basically the index ends up in a very inefficient >state. Try re-indexing the collection and see if it improves the query >time. >
When you say 're-index' the collection, do you mean to do a purge and then cfindex again? We do that every week. We are finding though the same results you are mentioning and that maybe we should delete the collection and start fresh every week. Any other thoughts? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4