Case Study: Island Water Technologies | Torq IT

By:
Case Study
.................................................................

Performance Tuning Increased

Customer Happiness

The Client

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.

The Problem

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.

The Torq IT Solution

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.

Results

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.

  • "IWT transitioned support of the custom backend and data dashboard to Torq IT in 2019. It was a very nervous time as our clients rely on the service to interact with the SENTRY product. With only limited documentation Torq IT was able to maintain the service immediately. Torq IT has been able to improve the quality of the service as quantified by faster service response time and achieving zero server downtime for the past 3 months. Complaints from clients regarding service response have been evaporated."
  • Colin Ragush
  • Technology Lead, Island Water Technologies
  • "We have worked with Torq IT for several years now. Torq has created custom business intelligence tools and system integrations for our business that are core functionality. Torq takes the time to listen and understand what the system requirements are, and provides meaningful real world explanations of potential paths. They then execute these plans into real tools. I highly recommend Torq's services."
  • Dave Iwankow
  • Director of Digital, AmerCareRoyal
  • "Torq IT developed a customer portal and business intelligence suite for our business. The project was delivered professionally, on time and on budget."
  • Eric Paladino
  • Vice President of IT, AmerCareRoyal

Let's build something amazing together.

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.

READ MORE

About Us

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.