Search Posts
Search blog posts by title, description, tags, or content.
Back to About
On-premise DPM Monitoring System Refactoring
EXEM · Jan 2024 - May 2024
JavaSpring BootMyBatisPostgreSQL
Tasks
- •Reworked MyBatis queries with subquery structures to avoid query-size limits from large parameter sets
- •Combined multiple split read queries into a single query to improve response performance
- •Implemented core business logic for a database analysis tool
Achievements
- •Improved large data read performance to respond within 100ms to 3s
- •Provided database status and analysis metrics visually in the user interface