Уровень 0 · материалов: 5
В кластер входят документы о методах написания прикладного кода и использовании ORM для повышения производительности БД, но не входят общие настройки СУБД или архитектурное масштабирование.
Общие признаки: снижение количества запросов, пакетная обработка данных, эффективное использование ORM, стандарты написания кода T-SQL и PL/SQL, минимизация переключений контекста
Группа выше: Оптимизация SQL-запросов
Смысл: The main idea is that most ORM implementations prioritize development speed and abstraction over database performance, resulting in inefficient 'small DML' bursts that choke the database transaction log. True progress in ORM requires moving from single-object operations to efficient, set-based batch operations at the platform level.
The author demonstrates that ORM abstractions often cripple database performance by generating excessive small DML operations that bottle-neck the transaction log, arguing for a shift toward native set-based batching.
Смысл: The main idea is that while Django ORM is a powerful tool for productivity and maintainability, it can lead to severe performance bottlenecks in high-load projects if the developer does not understand how it translates to SQL. Efficiency is achieved by minimizing the number of queries (avoiding N+1), selecting only necessary fields, and avoiding complex ORM abstractions for heavy computations.
A technical guide on avoiding common Django ORM pitfalls to prevent database bottlenecks in high-traffic applications.
Смысл: The main idea is that achieving high throughput in Oracle requires moving away from row-by-row processing and automatic transaction management toward batch operations, bind variables, and efficient database-side processing.
The text provides a technical guide on increasing Oracle database insertion speeds from hundreds to thousands of records per second through batching and architectural optimizations.
Смысл: The main idea is to improve the performance and maintainability of PL/SQL code through the adoption of strict team standards, modern version control, and the use of bulk processing techniques to minimize engine context switching.
A technical guide on optimizing Oracle PL/SQL code through team standards, Git versioning, and the use of BULK COLLECT and FORALL to reduce context switching.
Смысл: The main idea is to provide a rigorous set of coding standards and optimization techniques for T-SQL to ensure high performance, scalability, and maintainability of database objects.
A detailed technical guide containing 54 best practices for optimizing and structuring T-SQL code in MS SQL Server.