Boy, it's just my day for search-related questions. I'm seeing something weird here and want to know if this is normal. I'm creating an index from a database query. The collection contains about 14k records, and the initial collection size (immediately upon creation) is about 79MB.
Optimizing that collection after it is created reduces the collection size to about 37MB! Now, given that all the total size of my database is only about 100MB and that there is a ton of other data in there, I'm willing to believe that the post-optimization size is the correct one, and that collections suffer from some amazing bloat when they are created. So, first, is my experience consistent with that of others, and second, would a better strategy be to create a collection and then optimize it immediately afterwards? Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:216248 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
