Уровень 0 · материалов: 7
В кластер входят документы, посвященные техническим методам повышения эффективности работы СУБД и написания SQL-запросов, и не входят документы, касающиеся общего программирования или администрирования систем без привязки к производительности БД.
Общие признаки: повышение производительности SQL, стратегии индексирования, оптимизация запросов, архитектурные ошибки баз данных, масштабируемость систем
Группа выше: Индексы и настройка СУБД
Смысл: The main idea is that database performance in high-load systems is often throttled by inefficient query architecture and a lack of proper indexing. The author advocates for moving away from generic SQL patterns toward specific optimizations—such as denormalization and covering indexes—to reduce server load and response times.
A guide to optimizing MySQL for high-traffic sites through specific query tweaks, covering indexes, and strategic denormalization to avoid slow temporary tables and filesorts.
Смысл: The main idea is to improve database performance by avoiding common anti-patterns in MySQL query writing. The text advocates for minimizing the number of requests, reducing the volume of transferred data, and ensuring that indexes are utilized effectively to optimize system resource usage.
A technical guide detailing common MySQL query mistakes and providing optimized patterns to enhance database performance and scalability.
Смысл: The main idea is that readable code is insufficient; it must also be performant. By understanding how the SQL Server engine, indexes, and the query optimizer work, developers can avoid common architectural mistakes that lead to severe performance degradation as data volume grows.
A technical guide outlining seven common T-SQL coding errors—such as implicit type conversion and row-by-row processing—that severely degrade SQL Server performance.
Смысл: The main idea is that database inefficiency is a primary cause of slow website performance as a project scales, and it can be mitigated through a combination of precise measurement, strategic indexing, query optimization (JOINs), and intelligent caching.
A technical guide on diagnosing and fixing slow website performance through MySQL database optimization, indexing, and caching strategies.
Смысл: The main idea is that MySQL performance can be significantly improved by focusing on three critical areas: the strategic implementation of indexes, the rigorous design of the database schema, and the writing of set-based, efficient SQL queries.
A practical guide to optimizing MySQL performance by improving indexing strategies, database schema design, and SQL query efficiency.
Смысл: The main idea is to bridge the gap between application development and database administration by providing developers with practical strategies to improve SQL Server performance, scalability, and reliability while avoiding common architectural mistakes.
A professional guide offering seven performance and architectural tips for developers to optimize their interaction with Microsoft SQL Server.
Смысл: The main idea is a reflection on the trade-off between engineering perfection (high-performance C code) and business pragmatism (a 'good enough' SQL solution). It demonstrates that for low-load systems, leveraging existing database features can be more efficient for the business than building complex, high-performance specialized software.
An engineer jokingly suggests building a crypto exchange matching engine in MySQL, only to actually implement it and find that it surprisingly met the business's low-volume needs.