Posts

Showing posts from July, 2025

Coffee With QA Guy

 Do more unit testing. Have Confident answers. Think of all the cases before starting.

Group deletion

  Daily Learning Log Entry Date: July 10, 2025 Developer: Abdul Rahman Kidwai Project: Group Deletion Performance Optimization 🎯 Problem Statement Group deletion operations were taking 10+ minutes for 376 filter deletions, causing poor user experience and potential timeout issues. 🔍 Learning & Discovery Process Initial Investigation Assumption : Blob storage was the bottleneck Reality Check : Database operations were the real performance killer (80-200 seconds per operation) Key Insight : Always profile before optimizing - assumptions can be wrong Root Cause Analysis Database Issues : 376 individual SQL operations instead of bulk operations Azure Storage Throttling : Unlimited concurrent requests triggering rate limits Thread Pool Concerns : Risk of exhausting web server resources with long-running operations 🔧 Technical Solutions Implemented 1. Database Bulk Operations (Primary Solution) Before : 376 individual DELETE statements After : 3 bulk SQ...