Terms starting with "Q"
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.
3mo 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.
3mo 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.
3mo ago
Data Structures beginner
Query Optimisation
PHP 5.0+
1
Analysing and rewriting database queries to reduce execution time, I/O, and resource usage.
3mo 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.
3mo 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.
3mo ago
Performance intermediate