SBsaikat boseinifs-techy.hashnode.dev·Jul 26 · 7 min readAdvanced Indexing Strategies for Customized TablesI got called in to debug a "critical performance issue" once. IFS form taking 50+ seconds to load. Queries timing out. Admins panicking. Everyone's frustrated. I pull up a SQL trace and look at the qu00
SBsaikat boseinifs-techy.hashnode.dev·Jul 19 · 5 min read5 Common BPMN Design Mistakes That Tank PerformanceI got called in to debug a BPMN workflow once that was causing the entire system to slow down. The workflow looked fine on paper. Approvals, routing, notifications—all standard stuff. But when I trace00
SBsaikat boseinifs-techy.hashnode.dev·Jul 12 · 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
