Performance Tuning Increased
As a company, Island Water Technologies (IWT) develops cutting edge wastewater monitoring and treatment solutions. The Sentry solution by IWT is a unique bio-electrode sensor technology that allows for real-time monitoring of microbial metabolic activity in anaerobic and aerobic wastewater treatment systems.
With increasing adoption rate of SENTRY in the market, IWT required the expertise of a software development team to support Sentry. The processes for managing the codebase were not standardized and error-prone. It was hard to perform development on the application as it required a lot of system dependencies. Furthermore, the performance of the application was suffering. Sentry sensors collect data every minute, and with hundreds of sensors in the field, the application logs over 2 million data points into the database every week. When collecting such a large quantity of data without optimizing the SQL queries, the application grows to be very slow. Some pages took 30s or more to load, and others would not load at all.
Torq IT quickly took over management of the codebase and streamlined development to improve application performance and practices in a few ways:
Architecture: The application was rearchitected to reduce the number of database calls and allow the database to work more than the application.
Release Process: Steps in the software delivery process were automated. This prevents manual errors, provide standardized workflows for developers, and enables fast releases to production.
Development: A standardized development environment build on Docker was added to ensure that developers were all operating in a consistent environment.
Island Water Technologies is now able to operate in a standardized development environment and efficiently display weeks worth of data with the largest reports rendering in < 5s. They are now also confident in the stability of the system for their customers.
Would you like to speak to one of our experts? Please submit your details below and we'll be in touch shortly. Don't worry all of our quotes are free.
We’re the tradesmen of IT, a small pit crew of professional developers and consultants who get under the hood to solve problems and make business more efficient. From defining a project to developing and maintaining the tools needed to get results, we design the software you need to improve your operations.
A Gold Level Pimcore partner, Torq IT uses Pimcore’s innovative platform to create custom software solutions for clients across North America. We look at problems from all angles and do whatever it takes to work out the kinks — your challenges fuel our passion.