Introduction to Drupal performance tuning, focusing on database optimization, query analysis, and monitoring tools for better web application speed.
A guide on replacing Drupal's resource-intensive database logging with the Syslog module for better performance.
Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.
A guide to using MiniProfiler for performance profiling and identifying bottlenecks in ASP.NET MVC applications, focusing on database queries and server-side timing.
A technical guide on reducing SQL database size by normalizing repeated data like IPs and User Agents into separate relational tables.
A technical guide on safely converting a SQL Server primary key index from nonclustered to clustered (or vice versa) using a temporary unique constraint.
A developer details optimizing a Django view to analyze chat log data, reducing execution time and database queries.
Technical analysis of optimizing an Identity Mapper in Django, focusing on query reduction and in-process caching strategies.
Explains how to create an efficient timeline view in Django by merging multiple sorted querysets to minimize database queries.
