Shining a light on database performance
Our team of highly skilled developers have given the Operations module a performance boost.
A team of highly skilled developers have pulled back the carpet on the Operations module to give its database some performance enhancing updates. The database performance improvements come as a result of a six month project which involved identifying and rectifying inefficient code. The outcome has seen a boost in database performance for previously problematic areas of the system.
Custom-designed Pulse application Torch was used to complete the project. Named for its ability to shine a light into database performance, the application monitors database activities in order to identify resource intensive database activities. It then provided logs, which were used to optimise queries through smarter and more efficient code.
Some of the most valuable gains came from discovering inefficient queries which at first glance appeared fine.
Speed increases for Production screens
|Before (seconds)||After (seconds)||Speed Increase|
|Processing Data Entry Screen||5.87||5.34||9%|
|Refresh Equipment List||11.95||8.36||30%|
|Production Data Entry||9.24||8.34||10%|
|Save Adjustments||2min 56sec||1min 52sec||36%|
Aside from the database enhancements, the development team involved in the project gained valuable insight into how underlying technologies worked and their impact on system performance.
‘They [the developers] relished the challenge to get the best out of the tools they have. We are lucky to have such a passionate and driven team.’ – Aaron Halverson, Operations Module Lead.