J
James Palmer
Guest
I thought as much. If you're running a more modern version of Progress (10.x or later), and you should be moving that way if you're not already as 9.x is now unsupported, then your data should be in Type II storage areas. Type II storage areas completely remove the necessity to dump and load on such a regular basis. Ours hasn't been done for at least 5 years, and the only real reason I'm looking to do it now is to restructure the storage areas. Add to that, that in 11.x (not sure of exact version) you can compress indexes online, which pretty much does the same as an index rebuild, so you can maintain index fragmentation online as well.
Continue reading...
Continue reading...