A developer details optimizing a PHP script to process 11 million database rows in seconds, focusing on SQL query batching and moving logic to PHP.
Explains how hardware performance depends on software selection and tuning, using a three-stage rocket analogy for tech leaders.
A review of the book 'Troubleshooting Java,' covering debugging, profiling, and performance tuning for Java applications.
Explains how Kubernetes API server concurrency controls like --max-requests-inflight work to manage performance and prevent overload.
Deep dive into sizing the central request queue for Java 25's new CPU-time profiler, balancing performance and memory usage.
A guide for Oracle DBAs on PostgreSQL query tuning, covering the pg_stat_statements extension and the PostgreSQL planner's cost model.
PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.
A guide to using Releem, a tool for MySQL performance tuning and monitoring, including installation and configuration steps.
PostgreSQL 18 will allow dynamic adjustment of autovacuum_max_workers without a server restart, improving database maintenance flexibility.
Final guide in a series covering performance tuning and best practices for optimizing Apache Parquet files in big data workflows.
Analyzing Twitter's container CPU throttling issue, its causes, and potential solutions for significant performance and cost savings.
Explains how to reduce memory usage for multiple .NET services on a single machine by disabling server garbage collection.
Explains how to configure the number of History service shards in Temporal for optimal performance, balancing contention and resource use.
A developer shares the value of SQL Server Profiler for debugging and performance analysis, offering tips for creating effective custom trace templates.
How Twitter built LongTermMetrics (LTM), a system that identified and shipped millions in cost savings by analyzing JVM metrics.
Announcing a full-day SQL workshop on optimizing data warehouses using Columnstore Indexes, from basics to advanced tuning, at SQLSaturday Madrid 2018.
Announcing two full-day SQL Server workshops at SQLSaturday Lisbon 2018, featuring Query Store troubleshooting and performance tuning.
A guide to optimizing PHPStorm's performance through VM options, disabling unused plugins, and managing project indexing.
A guide to using Java 9+'s unified logging architecture with the -Xlog option to configure JVM internal messages.
A guide on how to disable Intel Hyper-Threading Technology on Amazon Linux EC2 instances for specific workloads like HPC.
