Tag Archives: application development

Leveraging Sequence Diagrams for SQL Optimisation: A Non-Functional Perspective

Leave a Reply

This article explores how extending sequence diagrams to include non-functional aspects can help developers better understand and optimise SQL performance by highlighting often-overlooked details like database hits and data transfer volumes.

Continue reading →

Bridging the Divide: Understanding Application Development vs. Database Optimisation

Leave a Reply

This article explores the divide between application developers and database administrators, highlighting how their differing focuses can lead to inefficiencies in SQL performance. It discusses the importance of bridging this gap by encouraging collaboration and a unified approach to optimise both application logic and database performance.

Continue reading →