Database queries in loops are performance killers. Load all needed data in one query, then process it in memory. One query fetching 1000 records beats 100 queries fetching ten records each by far. #SoftwareEngineering
Database queries in loops are performance killers. Load all needed data in one query, then process it in memory. One query fetching 1000 records beats 100 queries fetching ten records each by far. #SoftwareEngineering