Trends Feature Optimizing Performance on Public Domain Databases Most Web application development entails the use of a database. If so, you should familiarize yourself with the methods for getting the most out of your database. The quickest way to improve your code's performance is to replace your inline SQL statements with stored procedures.
Stored procedures are routines that are stored in the database.
In addition, stored procedures are much easier to maintain. It is also easier to be certain that your business logic conforms to your functional requirements across the board if all your code refers to a single point. If your procedures are generic enough, you can reuse them in several projects and cut your development time. Finally, if scalability is an issue, it is much easier to scale your application code across several application servers if most of the database access logic is stored and executed inside the database. Storing blobs in the file system requires a little more work, but you get much better performance than if they are stored in the database.