Houston, We Have Problems with the Queries | Testμ 2023

About the talk

Explore this session withAndres Sacco, Technical Leader at TravelX, as he addresses the challenges with queries in 'Houston, We Have Problems with the Queries.'

About Andres Sacco

Andres Sacco has been working as a developer since 2007 in different languages, including Java, PHP, NodeJs, Scala, and Kotlin. Most of his background is in Java and the libraries or frameworks associated with this language. In most of the companies he worked for, he researched new technologies to improve the performance, stability, and quality of the applications of each company. In 2017, he started to find new ways to optimize the transference of data between applications to reduce the cost of infrastructure. He suggested some actions, some applicable in all the manual microservices and others in just a few.

Video Chapters

00:00 Introduction

39:36 QnA

44:40 Conclusion

Key Topics Covered

Introduction to Query Performance Issues: The speaker begins by discussing the common performance issues that can arise with queries in microservices, such as increased response times and latency, and how these issues can impact the overall performance of APIs.

Identifying and Diagnosing Performance Issues: Various strategies for identifying and diagnosing performance issues are explored, including end-to-end testing, performance testing, use of APM (Application Performance Management) tools, and logging. The limitations of each approach in pinpointing the exact source of performance issues in a distributed architecture are also discussed.

Tools for Performance Testing and Analysis: The video compares different tools for performance testing and analysis, including JUnit, QuickPerf, Gatling, and JMeter, highlighting their capabilities, ease of implementation, and how they can be used to detect performance issues.

Practical Examples and Solutions: The speaker provides practical examples of performance issues in a microservices architecture, demonstrating how to use QuickPerf, a Java library for writing performance-related tests, to identify and analyze problematic queries. This includes setting up tests to validate the number of executed queries and their performance impact.

Best Practices for Performance Testing: Towards the end, best practices for performance testing are shared, emphasizing the importance of creating performance tests for complex queries, integrating performance testing into the development pipeline, and setting up alerts to detect performance issues proactively.

Q&A Session: The video concludes with a Q&A session where the speaker addresses questions related to unexpected performance challenges, writing good test cases for database testing, and ensuring the stability and efficiency of the query system moving forward