Terms starting with "Q"
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.
b7
Messaging intermediate
Quadtree
A tree where each internal node has exactly four children, recursively partitioning 2D space for efficient spatial queries.
b5
Data Structures advanced
Analysing and rewriting database queries to reduce execution time, I/O, and resource usage.
b5
Performance intermediate
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.
b5
Database 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.
b5
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.
b3
Performance intermediate
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.
b3
Data Structures beginner