SBsaikat boseinifs-techy.hashnode.dev·1d ago · 6 min readQuery Optimization in IFS: The Hidden Performance Killer3 PM on a Monday. Support tickets pouring in. Users can't open the customer form—it just hangs. You know that feeling? I do. I spent the next 2 hours digging through SQL traces, refreshing coffee, mut00
UDUtsav Dattainutsavdatta-syslog.hashnode.dev·2d ago · 5 min readWhy I replaced CTEs with Temp Tables in SQL Server Stored ProceduresRecently I was working on some "SQL Performance Tuning", where I had to rewrite few stored procedures to improve their performance. While tuning stored procedures, I often found myself replacing CTEs 00
MEMohammed Ehabinmohamed-ehab.hashnode.dev·4d ago · 13 min read9 Real Fixes That Took My Next.js App's PageSpeed Score From Under 60 to 1009 Real Fixes That Took My Next.js App's PageSpeed Score From Under 60 to 100 I spent weeks chasing this. My PageSpeed score was sitting under 60, and for a while I genuinely didn't know why. Nothing "00
UDUxia Dovalinunrealengineoptimization.hashnode.dev·Jul 6 · 6 min readUnreal Engine OptimizationFrame Time (ms) vs Frame Rate (FPS) The Frame time (milliseconds) is a linear way of looking at performance, while the frame rate is non-linear. This means that the same change in FPS doesn't always r01D
BKBinay Kumar Dasinfindcoffeemate.hashnode.dev·Jul 5 · 4 min readThe Frontend Interview Question That Made Me Rethink Performance EngineeringA few weeks ago, I was interviewing for a Product Frontend role, and I got a question that I thought I had prepared for. The interviewer asked: "Users are complaining that your page takes 4–5 seconds00
UDUxia Dovalinunrealengineoptimization.hashnode.dev·Jul 4 · 2 min readUnreal Engine Optimization Hey, an Unreal Technical Artist here :)Welcome to my notes! Performance, profiling and optimization can be pretty tedious topics, but let's try to make them as simple as possible for everyone.I want t00
MMMihai Marinescuinfeaturingcode.com·Jul 2 · 19 min readDon't throw your layout into the binLayout thrashing, or how reading a number can freeze your page First of all, you can play with the layout trashing here. Here is a number that should not be possible. Two loops. Same work. The same 2,00
AMAlexander Matveeviniron-track.hashnode.dev·Jun 28 · 44 min readAnalyzing and Troubleshooting Bottlenecks in FastAPI: Optimizing Auth Flow, Cryptography, and Data SerializationThis article is intended for those who, like me, are interested in profiling and performance optimization. Key Takeaways (TL;DR): Offload CPU-bound crypto: Move synchronous operations like Argon2id 00
PSPawan Sharmainsharmapawan.hashnode.dev·Jun 27 · 10 min readInteraction to Next Paint Breakdown: Solving first move lag in BareBoardBackground So I was developing this dumb chess board which only contains presentation logic, emits event when a piece is touched and moved and doesn't have any move calculation/validation logic whatso00
RRishikantinrishiii2.hashnode.dev·Jun 26 · 5 min readThe Mathematics of Forgetting: Why Access Tracking is the Key to AI Memory DecayCuring AI's "Infinite Memory" Problem (Part 1): Fixing the Graph Database Bottleneck If you’ve ever built an AI agent using a Knowledge Graph, you've probably run into the Context Bloat problem. In th00
