Customer Stories
J Public Corporation
E-Procurement System Query Performance Improvement
Improved SQL performance and I/O efficiency to enhance usability and system stability.
- ClientJ Public Corporation
- ProjectE-Procurement System Query Performance Improvement
- IndustryPublic/Government
- SolutionsConsulting service
- HighlightsAnalyzed and improved the Top 10 performance-issue SQL queries
Faster Processing and Better Concurrent Performance
Analyzed key queries and improved performance through index optimization and SQL tuning for a stable system environment.
- Background
-
- Performance issues in frequently used procurement screens caused inconvenience for staff and external bidders
- Excessive single-column indexes and improper index design caused high I/O inefficiency
- Project Scope
-
- Identify problematic queries, analyze causes, and propose improvements
- Propose index improvements
- Identify problematic query patterns and provide improvement training
- Results
-
- Faster execution of key e-procurement screens
- Improved efficiency for concurrent external users - Improved system stability
- Faster execution of key e-procurement screens