Richard White wrote: > > I am sort of just asking general opinion. So you want more hearsay to counter the previous hearsay? We have lots of that in the archives.
> If we assume its gong to be > heavily loaded and be hitting the highest capacities. I think this is > best just for me to understand the limitations of the different > databases If you really want to understand databases, I recommend 'Concurrency Control and Recovery in Database Systems' by P. Bernstein e.a. for a thorough treatment of concurrency and locking issues. It is database agnostic and being able to classify databases along the different models helps a great deal in predicting their response to a certain workload. Combine that with 'SQL Tuning' by D. Tow for query optimization basics and you will be able to answer your own question :) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http: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:267602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
