Speed Up Your Application with Stored Procedure and Temporary Tables

As far as performance goes, the real benefit of stored procedures usually happens when you bundle several SQL statements into a single stored procedure. That's because the second-slowest thing you can do in a business application (right after reading and writing to your hard disk) is to send a request to another computer for processing. Reducing trips to the database is the kind of change that gets you the performance gain that matters -- the kind where your users say, "Hey, that was faster!"