![]() That's like speeding in the city - you just get to the next red light (the next database access) as fast as possible. Don't bother with programming changes that save milliseconds every thousand times through a loop. ![]() In all of those cases, I did the same thing: I sped up data access.ĭata access slows business applications down. In a third case, I eliminated a problem that caused an application to run slower and slower as the day went on until, finally, it would crash at about 2 p.m. In another case, I reduced the runtime of a batch application from seven hours to 45 minutes. I once cut the average response time for an application from more than four seconds to less than two. Doing that means doing a lot of things right, starting with your database design - and tweaking your ADO.NET code helps, too. NET Performance Tips: Speed up Data Accessįaster performance in business applications comes down to reducing the "critical two" - disk I/O and trips to the server.
0 Comments
Leave a Reply. |