Explore this session withAndres Sacco, Technical Leader at TravelX, as he addresses the challenges with queries in 'Houston, We Have Problems with the Queries.'
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.
00:00 Introduction
39:36 QnA
44:40 Conclusion
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
Testμ
Testμ (TestMu) by LambdaTest is an online-only conference that puts ‘you’ at the centre. It is by the community, for the community! Be it sessions on trends, hands-on learning sessions or talks on building the right culture, we keep ‘you’ at the centre of it all.
Selenide Appium - Mutated Java Appium Client | Amuthan Sakthivel | Testμ 2023 | LambdaTest
TestMu 2023Rainbows & Unicorns: Testing Serverless Application in AWS | Anaïs van Asselt | Testμ23 | LambdaTest
TestMu 2023How to Get Away with {{QA}} Manager's Failures | Dmytro Lukianchuk | Testμ 2023 | LambdaTest
TestMu 2023A Tester’s Journey in the World of Machine Learning | Shivani Gaba | Testμ 2023 | LambdaTest
TestMu 2023Chandni Chopra - Welcome Note Day 3 Testμ 2023 | Decode The Future of Testing I LambdaTest🚀
TestMu 2023Open Source for Personal and Professional Growth | Felipe Knorr Kuhn | Testμ 2023 | LambdaTest
TestMu 2023Testing Beyond Surface: Advanced Strategy for Rest API Testing | Julio de Lima |Testμ23 |LambdaTest
TestMu 2023Test Observability: Automation to Deep Observability for ROI | Vijay Kumar| Testμ 2023 | LambdaTest
TestMu 2023Expect to Inspect –Performing Code Inspections on Automation | Paul Grizzaffi | Testμ23 | LambdaTest
TestMu 2023My Crafting Project Became Critical Infrastructure | Elizabeth Zagroba | Testμ 2023 | LambdaTest
TestMu 2023Expanding the Horizon of Innovation in Testing | Mahesh Venkataraman | Testμ 2023 | LambdaTest
TestMu 2023Speedup App & Testing with GitHub & HyperExecute | Karan M.V. & Divya S.K. | Testμ23 | LambdaTest
TestMu 2023Removing Interrupts from End-to-End Test Automation | Panel Discussion | Testμ 2023 | LambdaTest
TestMu 2023Elevate your Testing Game: Appium 2.0 Plugin | Sai Krishna & Srinivasan Sekar | Testμ23 | LambdaTest
TestMu 2023Data & AI Quality Assurance in the Modern Age | Bharath Hemachandran | Testμ 2023 | LambdaTest
TestMu 2023AMA: Unveiling QA & SDET Evolution in Tech-Driven World | Babu Manickam | Testμ 2023 | LambdaTest
TestMu 2023