News

04/03/20

SQL optimisation saves machine resources

Our team is currently working hard on a great and large-scale platform for lawyers and their teams. One of the important functionalities of the solution is the customized summary reports. The team figured out that some reports that were implemented by developers of the previous development team take tens of minutes to run. After a few days of work, the report logic and the SQL queries were optimized, which reduced report execution time from minutes to milliseconds.
Daniel S. Jacobs, CTO of Law Ruler, wrote this thankful message to the team:
"I wanted to thank you for fixing the issue with our intake form. Alexander and Vasily figured it out. This problem was driving us nuts for years and they just fixed it in less than a week. As always, I am impressed with you and your team's work. Thank you!
--Dan Jacobs"