Terms starting with "Q"
Query Optimisation
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.
2mo 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.
2mo ago
messaging intermediate
Queues PHP 5.3+ A FIFO (First In, First Out) data structure — the first element enqueued is the first dequeued. Used for BFS traversal, job queues, rate limiting, and buffer management.
2mo ago
data_structures beginner
Query Optimisation PHP 5.0+ Analysing and rewriting database queries to reduce execution time, I/O, and resource usage.
2mo ago
performance intermediate
Query Plan & EXPLAIN Analysis
The execution strategy the database engine chooses for a query — analysed with EXPLAIN to identify full scans, missing indexes, and bottlenecks.
2mo 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.
2mo ago
performance intermediate