Intermediate terms
Query Optimisation
1
The process of rewriting SQL queries and database structures to reduce execution time — using EXPLAIN to identify full table scans, adding targeted indexes, rewriting JOINs, and eliminating N+1 patterns.
6mo ago
Database intermediate
Queue-Based Load Levelling
Using a queue between producers and consumers to absorb traffic spikes — producers enqueue at any rate, consumers process at a sustainable rate, preventing the backend from being overwhelmed.
6mo ago
Messaging intermediate
Query Optimisation
PHP 5.0+
1
Analysing and rewriting database queries to reduce execution time, I/O, and resource usage.
6mo ago
Performance intermediate
Query Plan & EXPLAIN Analysis
1
The execution strategy the database engine chooses for a query — analysed with EXPLAIN to identify full scans, missing indexes, and bottlenecks.
6mo ago
Performance intermediate
Queue Worker Tuning
PHP 7.0+
Configuring PHP queue workers (Laravel Horizon, Supervisor) for throughput, memory limits, graceful restarts, and concurrency — preventing job failures and memory leaks.
6mo ago
Performance intermediate