Tom Chiverton wrote: > Indexes make insert/update slower. yup.
> I used to work on a DB that had over a million inserts a month, with 'only' > several (tens of) thousend selects. We got better performane on the insert by > dropping some indexes, and the select performance was only slightly worse. sounds like a job for a staging table just for inserts w/out any indexes which moves the data via triggers or whatever to "real" tables for maintenance & querying. one way we handled municipal tax data at tax time (nobody comes to the municipality to pay their taxes until the very last nanosecond). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
