Today I ran into a performance/scalability problem with a group of stored procs I’d written earlier this week. All the procs passed basic unit-testing, but once I increased the load from processing 100 records to 100,000 records…you know, to make sure it scales and stuff…the test went from < 3 seconds to over 35 minutes!! […]
