Context, Stupid!
Explora cómo el contexto es crucial en la tecnología, desafiando creencias comunes en programación y bases de datos. Aprende a evaluar afirmaciones y evitar errores costosos en el desarrollo de software.
Optimizing Performance of Stateful Apps for Globally Distributed Users
Optimizing globally distributed stateful apps: strategies for minimizing latency, maintaining consistency, and keeping data close to users while ensuring security and reliability for mission-critical workloads.
Modern B-Tree Techniques
Explore advanced B-Tree techniques in databases and file systems, covering efficiency improvements, new functionalities, and hardware adaptations. Learn about PostgreSQL implementations and other database applications.
Intelligent Query Processing
Explore SQL Server optimizer advancements that improve performance without code changes, including techniques for table variables, user-defined functions, and common anti-patterns in T-SQL development.
Advanced Techniques for Real Time Detection of Polymorphic Malware
Advanced techniques for real-time detection of polymorphic malware, focusing on challenges like volume and metamorphism. Explores optimization strategies and evaluates effectiveness of current methods.
OpenZFS and Linux
Explore OpenZFS on Linux: installation, benefits, storage management, encryption, compression, snapshots, and optimization for various use cases. Learn to efficiently design and administer ZFS-based systems.
Optimize Python & Django Apps with Postgres Superpowers
Optimize Python & Django apps using Postgres techniques: analyze queries, eliminate loops, improve pagination, and scale horizontally with Hyperscale (Citus) on Azure for better performance.
Big O No - Django ORM Runtime Complexity and How to Avoid It Using LATERAL JOINS
Optimize Django ORM queries using SQL aggregations and LATERAL JOINs to solve N+1 query problems and improve performance in complex data retrieval scenarios, especially for GraphQL and REST APIs.
Building Scalable Web Apps
Learn strategies for developing high-performance web applications that can handle increased traffic and user loads efficiently, ensuring optimal functionality and user experience.
From Days to Minutes, From Minutes to Milliseconds with SQLAlchemy
Optimize SQLAlchemy performance by addressing N+1 queries, improving mass operations, and understanding ORM-database interactions for significant speed improvements.
Durabilidad diferida de transacciones y mejoras en gestión de bloqueos para tareas
Explora avances en durabilidad diferida de transacciones y gestión de bloqueos, optimizando el rendimiento y la eficiencia en sistemas de bases de datos.
Dealing with Multipurpose Procs and PSP the Right Way
Learn effective strategies for handling multipurpose stored procedures and plan-stability problems in SQL Server, improving query performance and database efficiency.
Page and Row Compression Deep Dive
Explore advanced techniques for optimizing database performance through in-depth analysis of page and row compression strategies for DBAs.
Batch Execution Mode on Rowstore Indexes
Explore SQL Server 2019's Batch Execution Mode for Rowstore Indexes, its benefits, challenges, and optimal usage scenarios to significantly enhance workload performance.
Databases
Explore database performance optimization, IO challenges, and filesystem behaviors. Gain insights from industry experts on improving database systems and addressing common issues in Linux environments.
TiFlash - Make TiKV 10x Faster and HTAP-able
Explore TiFlash, a novel component for TiKV that enables HTAP capabilities, offering 10x faster analytical processing and strong workload isolation through a Raft-based architecture and columnar storage.
Massive.js
Explore Massive.js, a JavaScript framework for building large-scale applications, presented by Erich Gamma at JSConfUS 2013.
Software Performance Optimization and Scaling
Explore strategies for optimizing and scaling software performance, from code optimization to architectural design, caching, and microservices. Learn best practices and future trends in software optimization.
Optimizing Test Suites - Reducing Excessive Database Calls
Optimize test suites by reducing database calls. Learn profiling, diagramming, and coding techniques to improve build times and performance.
LingoDB: An Open Compilation and Optimization Framework for Sustainable Data Processing
Discover how LingoDB's open-source framework enables efficient data processing through flexible architecture, cross-domain optimizations, and seamless adaptation to modern hardware capabilities.
Billions of Records in MySQL: Lessons Learned
Explore strategies for managing billions of MySQL records, covering optimization, storage engines, schema design, and backup techniques for large-scale databases.