← CodeClarityLab Home
Browse by Category
+ added · updated 7d
🤖 AI Guestbook — #performance educational data only
| |
Last 30 days
89 pings — 2026-04-08 W 8 pings — 2026-04-09 T 61 pings — 2026-04-10 F 93 pings — 2026-04-11 S 59 pings — 2026-04-12 S 89 pings — 2026-04-13 M 19 pings — 2026-04-14 T 10 pings — 2026-04-15 W 15 pings — 2026-04-16 T 99 pings — 2026-04-17 F 75 pings — 2026-04-18 S 150 pings — 2026-04-19 S 67 pings — 2026-04-20 M 21 pings — 2026-04-21 T 44 pings — 2026-04-22 W 73 pings — 2026-04-23 T 131 pings — 2026-04-24 F 194 pings — 2026-04-25 S 57 pings — 2026-04-26 S 14 pings — 2026-04-27 M 29 pings — 2026-04-28 T 67 pings — 2026-04-29 W 103 pings — 2026-04-30 T 150 pings — 2026-05-01 F 133 pings — 2026-05-02 S 81 pings — 2026-05-03 S 33 pings — 2026-05-04 M 31 pings — 2026-05-05 T 31 pings — Yesterday W 93 pings — Today T
Amazonbot 12Perplexity 8ChatGPT 3Google 1
ChatGPT 5Google 2Amazonbot 1Claude 1
Amazonbot 1.6kPerplexity 1.3kGoogle 583Unknown AI 412Ahrefs 404ChatGPT 380SEMrush 167Majestic 71Claude 70Meta AI 34Qwen 6DuckDuckGo 2Bing 1
crawler 4.8k crawler_json 224 pre-tracking 76
Tag total5.1k pings Terms pinged220 / 220 Distinct agents12
Level All Beginner Intermediate Advanced Tag: performance
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Memory Pressure Detection PHP 7.0+
Proactively identifying when a PHP process approaches its memory limit so corrective action can be taken before a fatal error.
2d ago performance intermediate
Database Query Result Streaming PHP 8.0+
Processing large result sets row-by-row without loading the entire dataset into memory - essential for PHP CLI scripts handling millions of rows.
5d ago database intermediate
Prompt Caching
API feature where a static prompt prefix (system instructions, large context) is cached server-side, dramatically reducing cost and latency on repeated calls that share the prefix.
1w ago ai_ml intermediate
Memory Management in JavaScript
JavaScript uses automatic garbage collection — the engine reclaims memory when objects are no longer reachable. Memory leaks occur when references are unintentionally retained, preventing collection.
4w ago javascript intermediate
Core Web Vitals
Google's three field-measured performance metrics — LCP (loading), INP (interactivity), CLS (visual stability) — used as direct search ranking signals since 2021.
1mo ago performance intermediate
Cumulative Layout Shift (CLS)
A Core Web Vital that measures unexpected visual movement of page elements during load — caused by images without dimensions, late-injected content, and font swaps. Target: under 0.1.
1mo ago performance intermediate
Image Optimisation
Reducing image file size and delivery overhead through format choice (AVIF, WebP), compression, responsive sizing (srcset), lazy loading, and explicit dimensions — the single highest-impact performance lever for most websites.
1mo ago performance intermediate
Largest Contentful Paint (LCP)
A Core Web Vital that measures when the largest above-fold content element (typically the hero image or main heading) becomes visible — target under 2.5 seconds. The most impactful page speed metric.
1mo ago performance intermediate
Resource Hints (preconnect, prefetch, preload)
HTML link attributes that instruct the browser to take early action on resources — opening connections, fetching future pages, or loading critical assets before they are discovered in HTML parsing.
1mo ago performance intermediate
Script Loading (defer, async, type=module)
How and when browser downloads and executes JavaScript — defer, async, and type=module control whether scripts block HTML parsing and in what order they run.
1mo ago frontend intermediate
HTTP/2 Server Push & Early Hints
HTTP/2 Server Push lets a server proactively send assets (CSS, JS, fonts) before the browser requests them. 103 Early Hints is its practical successor — sending Link preload headers before the full response is ready.
1mo ago networking intermediate
Memory-Mapped Files
A file mapped directly into a process's virtual address space — reads and writes go through the OS page cache rather than read()/write() syscalls, enabling fast access to large files and shared memory between processes.
1mo ago linux advanced
MySQL Connection Pooling PHP 5.1+
Reusing database connections across requests instead of opening and closing a new connection on every request.
1mo ago php intermediate
MySQL EXPLAIN
A MySQL query analysis command showing the execution plan — which indexes are used, how many rows are scanned, and where bottlenecks are.
1mo ago database intermediate
Diagram: MySQL Index Types MySQL Index Types
B-tree, FULLTEXT, SPATIAL, and HASH indexes — each optimised for different query patterns.
1mo ago database intermediate
MySQL LIMIT and OFFSET Pagination
LIMIT restricts result row count; OFFSET skips rows for pagination — but OFFSET-based pagination degrades on large tables.
1mo ago database intermediate
MySQL Query Cache (Deprecated)
A server-side cache for SELECT results removed in MySQL 8.0 — it caused severe scalability issues under concurrent writes.
1mo ago database intermediate
MySQL Subqueries
A query nested inside another — useful for filtering and deriving values, but correlated subqueries re-execute per outer row and can be O(n²).
1mo ago database intermediate
Diagram: N+1 Query Problem N+1 Query Problem PHP 5.1+
A performance anti-pattern where fetching N records triggers N additional queries — one per record — instead of a single JOIN.
1mo ago database intermediate
PHP Generators PHP 5.5+
Functions using yield that produce values lazily — one at a time — instead of building a complete array in memory.
1mo ago php intermediate
✓ schema.org compliant