Houston, We Have Problems with the Queries

Watch the Session

About the Talk

Houston, We Have Problems With The Queries

Most developers create some queries on the applications without checking if the performance is correct or not. Sometimes problems appear in production with many requests that affect the database or the application. The solution is to create some unit test that detects these problems.

During this talk, you will see how the performance problems on the queries could affect an API in different aspects. Some of them are connected with the harmful use of the join operations, but others imply that you wrote the query without the assistance of any framework.

You will see a short scenario with a microservice that executes different queries to insert/update or obtain the information from other tables with performance issues. This scenario will help you to learn how to create some test on the layer that access the database and include some library like QuickPerf to analyze and detect problems in the performance.

Key Takeaways

• Mid-developers or up who have specific knowledge of testing, like unit testing. Having experience with some particular framework is unnecessary because the talk tackles the idea of creating performance tests for the queries.

About the Speaker

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 of them applicable in all the manual microservices and others in just a few. All this work concludes with the creation of a series of theoric-practical projects, which are available on the page Manning.com Recently he published a book on Apress about the last version of Scala. Also, he published a set of theoric-practical projects about uncommon ways of testing like architecture tests and chaos engineering. He dictated internal courses to different audiences like developers, business analysts, and commercial people. Also, he participates as a Technical Reviewer on the books of the editorials: Manning, Apress, and Packt.

The free online Testµ (TestMu) conference by LambdaTest will talk about trends that matter in the testing landscape and will help testers & developers get a glimpse into the future of testing. Over 30+ speakers including community leaders and leading industry experts will join the event to share their thoughts.