About the client
The client is a leading family-operated restoration contractor based in the US. It specializes in restoration, environmental remediation, and reconstruction services after natural and man-made disasters. Its expertise and specialization have positioned it as a trusted industry frontrunner.
Client challenges
The client’s existing job conversion code faced difficulties due to its structure and the performance limitations in the Salesforce Org. The codebase remains poorly organized, with redundant functions spread throughout, which leads to longer execution times and increased resource consumption.
The heavy reliance on SOQL queries adversely affects database performance and hinders optimal utilization. As a result, the client experiences a decline in user experience and potential scalability issues as the application expands. They require expert assistance to ensure sustainable performance and scalability over the long term.
Solution
- LevelShift’s experts refactored and streamlined the job conversion code, significantly improving productivity by eliminating redundancies.
- We optimized SOQL queries to enhance database performance and reduce resource consumption and execution times.
- Comprehensive testing revealed substantial performance gains, and the code supported future scalability.
Benefits
The optimization solution resulted in improvements in both system performance and user experience.
- Performance improvement: The refactoring and optimization efforts led to a 30% reduction in execution times and a 25% decrease in resource consumption during the job conversion process.
- Reduction in support tickets: Before optimization, our support team received about three tickets per day related to the “Too many SOQL queries” issue. Post-optimization, these tickets were eliminated, with a 20% reduction in related support incidents.
- Enhanced scalability and improved user experience: The system now handles increased data volumes and user loads more effectively.