17413 107 Ave NW #100, Edmonton, AB

Case Study: Query Performance Optimization

Introduction: At Framewerx, we are dedicated to delivering great user experiences through our applications. Recently, our team encountered a challenge with the query speed of the statusing feature in Shopwerx. Slow query speeds were affecting user interactions, prompting us to embark on a thorough investigation and implement strategic enhancements. In this case study, we’ll explore the steps taken to diagnose and resolve the query speed issue, resulting in a significant improvement in performance.

Diagnosing the Challenge: The first step in addressing the slow query speeds was a comprehensive diagnosis using tools such as Fiddler, Postman, SQL Server Management Studio (SSMS), and the Profiler. By deconstructing the abstracted SQL queries generated by Entity Framework (EF) Core LINQ queries, our team gained insights into the root cause of the performance bottleneck.

Strategic Utilization of Tools: Fiddler and Postman played crucial roles in capturing and analyzing HTTP traffic, while SSMS and the Profiler enabled a deep dive into the SQL queries executed by Shopwerx. This multi-tool approach allowed us to pinpoint the specific areas contributing to the slow query speeds.

Balancing Query Execution: After careful consideration, our team devised a solution to balance out the query execution by front-loading certain portions of it into memory. By converting these portions back into a queryable object, we created a more efficient structure that could accommodate OData query parameters. This strategic restructuring aimed to streamline the query execution process and enhance overall performance.

 

Results and Improvement: The implementation of the optimized query strategy yielded remarkable results. The statusing feature’s GET endpoints experienced a notable speed improvement of approximately 10-15 times, significantly enhancing the user experience within Shopwerx. Users can now enjoy quicker response times and smoother interactions, contributing to increased overall satisfaction with the application.

Conclusion: In addressing the query speed issue within Shopwerx’s statusing feature, our team demonstrated a commitment to delivering optimal user experiences. Through a meticulous diagnosis, the strategic use of diagnostic tools, and the implementation of an innovative query optimization strategy, we achieved a substantial improvement in performance. This case study underscores our dedication to continuous improvement and our ability to overcome challenges to deliver outstanding results.

Client Testimonials
Steve Brittain
Steve Brittain
Municipal Manager, Select Engineering Consultants
Read More
Dan and his team have been able to meet all Select Engineering challenges with minimal disruption to the business; from fast access to corporate resources thanks to our DaaS solution, to collaborating with internal and external parties utilizing our manager VoIP phone system or accessing SaaS solutions using the fully integrated security solutions.
 Daniel Elliot
Daniel Elliot
Operations Lead, Omni-McCann Geoscience
Read More
Framewerx rescued my company from obsolete digital file management and brought us into the 21st century with cloud services in an efficient manner. Kalyn and his team at Framewerx were able to provide solutions for merging two corporate entities with vastly different digital file management and email servers in a seamless manner while providing top quality support during and after the transition to all employees. They provided training so that everyone understood new operating protocols and software changes. Framewerx has been very responsive and has always been keen to work with us to understand our business, IT needs, and financial restrictions. We continue to work with Framewerx for all of our IT, phone system, and data storage needs.
 Karim Mouait
Karim Mouait
Vice President, Cornerstone Insurance Brokers Ltd
Read More
We used Framewerx to transition our traditional office to a virtual one. This included VOIP, call recording, video conferencing, VPN, remote working from home accommodations etc. Dan and his team did a fantastic job. They are extremely responsive and client service oriented.
 Kimberly Maber
Kimberly MaberManaging Partner, Brunsdon Lawrek & Associates
Read More
I have worked with Kalyn and his team for many years. He has readily handled all of our IT needs, from designing our IT strategy to our day to day computing requirements and support. Kalyn takes the time to listen to and understand our needs, delivering cost-effective and innovative IT solutions for our small business. I highly recommend working with Kalyn at Framewerx.
Services we provide
Latest Blog Posts

In today’s business landscape, data isn’t just power — it’s the very lifeline that fuels business decisions, drives innovations and shapes strategies. …

Your network is your business’s lifeline. A healthy and secure network is critical for seamless communication and operational efficiency. That’s why it’s …

Password protection is the best place to start if you want to ramp up your cybersecurity. Because of the frequent use of …

Inventory Management

Inventory Count Tool

Enhance inventory auditing and future reconciliation efforts with a versatile mobile and web-based application.

Fabrication & Progression Management

Shopwerx

Efficiently oversee and optimize the fabrication process of steel components, meticulously tracking and managing the progression of fabrication tasks from staging, prep assembly, welding, QAQC, all the way to shipping.