LowFile-scopePHP Plug & play

Use lazy loading/streaming for large datasets

Stream results (cursor/generator) or paginate instead of loading entire result sets into memory.

Why this matters

Reduces memory pressure and improves throughput on big tables.

Side-by-side examples engineers can pattern-match during review.

Avoid

$rows = $pdo->query('SELECT * FROM logs')->fetchAll(); // huge

Prefer

$stmt = $pdo->query('SELECT * FROM logs');
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // process row
}

Bad

fetchAll()

Good

while($row=$stmt->fetch(...)) { ... }

From the same buckets as this rule.

Critical
Avoid Blocking Calls to Async Methods
Blocking async methods with `.Result` or `.Wait()` can cause deadlocks and prevent efficient asynchronous execution. Use `await` instead for proper async behavior.
concurrency-safetyperformance-efficiency
Critical
Fingerprint assets and cache immutably
All static JS/CSS/font/image files MUST use content-hashed filenames (e.g., app.9c1a7b.js) and be served with "Cache-Control: public, max-age=31536000, immutable". HTML and other non-fingerprinted documents MUST be served with "Cache-Control: no-cache" (or equivalent) to enable conditional revalidation.
web-static-assetscaching-strategy+2
Critical
No live network or DB in unit tests—use fakes/mocks
Unit tests must stub or fake external HTTP/DB calls; allow real I/O only in integration/e2e tests tagged accordingly.
testing-qualityperformance-efficiency+1