Local community app

Solution Implementation

• We advise our client that for numerous issues like high response time, slow website uptime, we need to remove N+1 problems from queries and prevent Lazy Loading.

• we suggested our client inorder to combat multiple query hits in the background we can use caching and memoization where ever possible.

• The project had multiple users and sending mails and sms directly led to hazardous impact on the website for which we used sidekiq and redis for background processing Furthermore, due to lack of database indexing, the queries took more time to render data which was reduced by changing migrations and adding appropriate indexing as per the requirement.

• We also updated the ruby and rails version of the project to get various security patches.

• Another hurdle that we faced was queries where written in a way that made our website open to various SQL Injection, so queries were amended and standard query format was also reinforced throughout the project.

• For heavier queries that needed to be hit frequently, we created database views which made the site work even faster.

• Code optimisation and code reusability has been a priority and it was also implemented to make code cleaner and more readable.