
Overview
What we did
- Conducted a remote database performance and tuning audit of the main Oracle database, which supports InPho’s SMS gateway applications
- Used Oracle’s function-based indexes to allow the SMS batch process to complete much faster
- Conducted the necessary code change to the index structure and the programming changes to the Oracle PL/SQL packages
- Worked with InPho’s team to determine the business and scaling requirements for the new SMS, Chat, and IVR applications
- Provided detailed guidance on structuring InPho’s MySQL database architecture to deliver performance and availability under load
- Ensured scalability by implementing the separation of applications onto individual servers and MySQL instances
- Improved cost-effectiveness by implementing a secondary slave server running multiple MySQL slave instances that also ran specific MySQL versions as required by each application
- Provided 24/7 support and monitoring
Technologies used
- Oracle
- MySQL
Key Outcomes
Throughout the many years of our relationship, Pythian has been instrumental in maintaining our most critical applications. We’ve come to rely on their expertise for our daily support.
– Graeme Campbell, Technical Director, Operations, InPho

40 seconds to 2 seconds reduction in SMS gateway application response times
Improved customer satisfaction with the performance and responsiveness of applications
Explore our Database Services
No matter your business, no matter the challenge: Pythian’s solutions drive results.