Performance terms
🤖 AI Guestbook — Performance educational data only
|
|
Last 30 days
Agents 30
Claude 30
PetalBot 26SEMrush 2Ahrefs 2Google 2ChatGPT 2Perplexity 1Bing 1
Scrapy 677Amazonbot 549Perplexity 473Ahrefs 297Google 280ChatGPT 237SEMrush 220Claude 124Unknown AI 119Bing 98Meta AI 67PetalBot 46Majestic 34Qwen 13Sogou 11Common Crawl 3Twitter/X 2DuckDuckGo 1
Most referenced — Performance
Async Processing / Job Queues 1Pagination Strategies 1Caching Strategies 1Redis 1PHP Async Frameworks 1Image Optimisation 1Materialized Views 1Object Pooling 1
How they use it
crawler 3k
crawler_json 218
pre-tracking 14
Category total3.3k pings
Terms pinged66 / 66
Distinct agents17
When a cached item expires, multiple simultaneous requests all miss the cache and hit the database concurrently, overwhelming it.
3mo ago
Performance advanced
Storing computed results or fetched data so future requests can be served without repeating expensive operations.
3mo ago
Performance intermediate
A geographically distributed network of servers that caches and delivers static assets from locations close to end users.
3mo ago
Performance beginner
Content Delivery Networks cache responses at edge nodes close to users — reducing latency and origin load, controlled via Cache-Control headers.
3mo ago
Performance intermediate
Reusing a pool of pre-established database connections rather than opening and closing a new connection on every request.
3mo ago
Performance intermediate
Connection Pooling — pgBouncer & ProxySQL
PHP 5.0+
External connection poolers sit between PHP-FPM and your database — multiplexing hundreds of PHP connections onto a small pool of real DB connections.
3mo ago
Performance advanced
An index that contains all columns referenced by a query, allowing the database to answer it entirely from the index without touching the table.
3mo ago
Performance intermediate
The optimal pool size is smaller than you think — follow the formula (cores × 2) + effective_spindle_count rather than matching thread count.
3mo ago
Performance advanced
Indexes are data structures that allow the database to find rows matching a WHERE clause without scanning the entire table.
3mo ago
Performance intermediate
Splitting a large table into physical segments by range, list, or hash — enabling partition pruning, faster archival, and parallel scans.
3mo ago
Performance advanced
Horizontally partitioning data across multiple database instances by a shard key, scaling write throughput beyond a single server's limits.
3mo ago
Performance advanced
Debounce delays execution until input stops; throttle caps execution to once per interval — both control the frequency of expensive operations.
3mo ago
Performance intermediate
Eager Loading
PHP 5.0+
Loading related data upfront in a single query rather than deferring until access, preventing N+1 query problems.
3mo ago
Performance intermediate
Eager vs Lazy Loading — When to Use Each
PHP 5.0+
Eager loading fetches related data upfront in one query; lazy loading defers it until accessed — the wrong default causes N+1 or over-fetching.
3mo ago
Performance intermediate
Excessive File I/O
PHP 5.0+
Reading the same file multiple times inside a loop or across repeated calls — avoidable with simple in-memory caching.
3mo ago
Performance intermediate
Flame Graphs for PHP Profiling
PHP 5.0+
A visualisation of sampled call stacks showing where CPU time is spent — the fastest way to identify hot paths in a PHP application.
3mo ago
Performance intermediate
Full-Text Search
PHP 5.0+
1
Efficient natural-language search across text fields using inverted indexes — far faster than LIKE '%query%' for large datasets.
3mo ago
Performance intermediate
Gzip / Brotli Compression
Compressing HTTP responses server-side reduces transfer size significantly, especially for text-based assets.
3mo ago
Performance beginner
HTTP Caching (ETags, Cache-Control)
Standard HTTP headers that instruct browsers and intermediary caches on how long to cache responses and when to revalidate.
3mo ago
Performance intermediate
HTTP/2 & HTTP/3
1
Modern HTTP protocol versions that deliver significant performance gains via multiplexing, header compression, and (HTTP/3) UDP transport.
3mo ago
Performance intermediate