As part of the Early Software Access Program, MIP will have the opportunity to work with the Table Partitioning feature, even as it continues to go through its final phases of development by OpenEdge Engineering, providing feedback and offering suggestions for improvement before general availability later this year.
With MIP offering both Software as a Service (SaaS) and on-premise solutions, Hart says the new feature will be a tremendous benefit to them and their customers. “Our clients want to decrease the size of their live databases so they are more manageable. The idea is that with Progress OpenEdge Table Partitioning, the older data can be archived in a different partition so it is immediately available if need be. But from a transactional point of view, customers will only be dealing with their more recent, live data. OpenEdge 11.4’s Table Partitioning will make it far easier for our customers to manage their data, and it will significantly improve the performance of their applications.”
Hart says one of the biggest issues MIP’s customers face, particularly those with very large databases and a lot of online users, happens during nightly backups. “Sometimes, intentionally or unintentionally, the code is not always written in the most effective way when it comes to indexing, so you can end up with some significant table sweeps. And when you do a table sweep on a relatively large table your performance goes right out the window. We talked about starting up an archiving project to move that data out in a manual way. But we knew it would be very time consuming and costly. The OpenEdge Table Partitioning feature will offer a much easier and faster way to manage this archiving process. And our customers will realize the results far more quickly.”
Initially, MIP may partition data straightforwardly, for example by calling one partition “live” and the other “archive.” But to further optimize application performance, they may later choose to partition the live data further, using date ranges. The new OpenEdge feature will also enable users like MIP to carry out many administrative operations on a partition basis, allowing some partitions to remain on-line while performing maintenance on another, for example if there is a need to rebuild an index. “I appreciate that each partition can be locked and worked with on its own without affecting the other ones,” says Hart. “That is a tremendous benefit.”