Customer Stories
B Insurance
Server Performance Improvement through Query Optimization
Maximized work efficiency and stabilized operations through DB performance improvement and SQL tuning.
- ClientB Insurance
- ProjectCore Query & DB Server Performance Improvement
- IndustryFinance
- SolutionsConsulting service
- HighlightsSQL optimization for insurance design and DB stability
Faster Insurance Design Screens with Query and Server Optimization.
Improved the performance of customer insurance design screens and provided consulting for overall database server optimization
- Background
-
- Need to improve delays in frequently used insurance design screens
- Difficulty identifying performance issues due to complex source code
- Need to stabilize performance during peak transaction periods
- Project Scope
-
- Analyze SQL call logs for core screens
- Tune problematic SQL and remove unnecessary calls
- Analyze DB server WAIT EVENT causes and identify improvements
- Identify improper SQL patterns and provide training
- Results
-
- Improved response speed of insurance design screens and DB
- Easier analysis of complex programs
- More stable DB server operations
