J
James Palmer
Guest
Type II storage should be very high on your priorities list. You will not be able to leverage many of the new performance enhancements introduced in newer versions until you do. One such feature is the TABLE-SCAN option on a for each. This reads the records in a table without an index, rather in the order it finds them meaning it can be a lot quicker than an indexed for each or even a count(*). But there are other benefits, like improvements to the dump and load performance, and also the general benefits of Type II storage that you're missing out on. Yes there's a bit of work required to implement it, but it shouldn't be too difficult and there's a lot of advice out there on how to go about it.
Continue reading...
Continue reading...