✅ Fix Delete: .vs/ Then restart Visual Studio. Why IIS Express config cache becomes corrupted.
Day: December 14, 2025
WordPress Slow First Load — Autoloaded Options Table
Run this: SELECT * FROM wp_options WHERE autoload = ‘yes’; Too many rows = slow site. ✅ Fix Disable autoload on unused options. This alone can cut TTFB in half.
Windows 11 Laptop Overheats — Turbo Boost Gone Wrong
Turbo Boost causes thermal throttling loops. ✅ Fix Limit max CPU to 99%: Power Options → Processor → Maximum Processor State → 99% Why Disables Turbo without killing performance.
Windows 11 Slow Context Menu — The Explorer Extension Trap
Third-party shell extensions slow everything. ✅ Fix Disable non-Microsoft extensions using ShellExView. Result Instantly faster right-click menus.
AJAX “Works Once, Then Fails” — Cached POST Response
Some browsers cache aggressively. ✅ Fix fetch(url, { method: ‘POST’, cache: ‘no-store’ }); Especially important for forms authentication dynamic APIs
JS Memory Leaks — Forgotten Event Listeners
Single-page apps suffer badly from this. ❌ window.addEventListener(‘resize’, handler); ✅ window.removeEventListener(‘resize’, handler); Always clean up listeners on unmount or destroy.
HTML5 button Defaults to submit (Surprise!)
This causes accidental form submissions. ❌ <button>Click</button> ✅ <button type=”button”>Click</button> Rule Always set the button type explicitly.
CSS opacity Breaks Child Elements — Use RGBA Instead
❌ .card { opacity: 0.8; } This also fades text and icons. ✅ .card { background-color: rgba(0,0,0,0.8); } Why Opacity affects the entire element tree.
ASP.NET Core Health Checks That Actually Matter
Many health checks always return OK. ❌ Useless services.AddHealthChecks(); ✅ Useful services.AddHealthChecks() .AddSqlServer(conn) .AddRedis(redisConn); Why Kubernetes and load balancers rely on this.
ASP.NET Core “Slow Startup” — Reflection Scanning Trap
Large projects often scan assemblies repeatedly. ✅ Fix Disable automatic scanning where possible and register explicitly: services.AddScoped<IService, Service>(); Why Reflection is slow at startup — especially in containers.
SQL SELECT * — The Hidden Future Bug
Works today, breaks tomorrow. ❌ SELECT * FROM Users; ✅ SELECT Id, Name, Email FROM Users; Why Schema changes break consumers Pulls unnecessary data Slower network and memory usage
SQL “Index Fragmentation Panic” — When NOT to Rebuild
Many rebuild indexes blindly. ❌ Bad Habit ALTER INDEX ALL ON Orders REBUILD; ✅ Smart Rule Fragmentation < 5% → do nothing 5–30% → REORGANIZE 30% → REBUILD ALTER INDEX IX_Orders_Date ON Orders REORGANIZE; Why Rebuild = blocking + log growth.
C# Exception Handling — The Silent Performance Killer
Exceptions are expensive.They are not flow control. ❌ try { return dict[key]; } catch { return null; } ✅ return dict.TryGetValue(key, out var value) ? value : null; Rule If it can fail often → do NOT use exceptions.
C# “foreach Is Slower Than for” — Yes, Sometimes
On List<T> this matters in tight loops. ❌ foreach (var item in list) { } ✅ Faster for (int i = 0; i < list.Count; i++) { } Why foreach creates an enumerator for is index-based and faster Use this only in hot paths, not everywhere.
C# Span — The Secret to Zero-Allocation Performance
If you manipulate strings or byte arrays heavily, this matters. ❌ Common Allocation Trap var part = input.Substring(0, 10); ✅ Zero-Allocation Alternative ReadOnlySpan<char> part = input.AsSpan(0, 10); Why this is huge No heap allocation No GC pressure Perfect for parsers and hot paths