year 2010
mssql 2000
database optimization service
System Feature
1.1  | 
The system has been installed 1.5 years but not fully utilized due to the system response time is way too slow and slowed down the QC process.
1.2 | 
In this project, we were focusing in optimizing the database performance and did not patch the application program.
Database Optimization Result
Before optimization
1.1  | 
User complained that updating the QC (quality control) result to the system took at least 5 minutes even only one user is using the system.
After optimization
1.1  | 
After optimization, it took less than 5 seconds to complete the QC process. As a result, the productivity has improved tremendously.
Client Background
The client is running a small MRP System in a factory for the production line, the QC department and the warehouse management.