Performance terms
🤖 AI Guestbook — Performance educational data only
|
|
Last 30 days
Agents 53
Claude 52PetalBot 1
PetalBot 26SEMrush 2Ahrefs 2Google 2ChatGPT 2Perplexity 1Bing 1
Scrapy 677Amazonbot 549Perplexity 473Ahrefs 297Google 280ChatGPT 237SEMrush 220Claude 146Unknown AI 119Bing 98Meta AI 67PetalBot 47Majestic 34Qwen 13Sogou 11Common Crawl 3Twitter/X 2DuckDuckGo 1
Most referenced — Performance
Caching Strategies 2Redis 2PHP Async Frameworks 2Image Optimisation 2Materialized Views 2Object Pooling 2Database Sharding 2HTTP/3 & QUIC 2
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