In this tutorial we are going to talk about yet another powerful feature of database programming, Stored Queries. Most of the time we use ASP pages, we use them to retrieve or manipulate records in the database. These database connections are resource heavy and every query takes time on part of the server. Thus we should try to make use of everything possible to optimize and speedup database access as much as possible. One of the ways is to retrieve records as arrays which I discussed in my article ' Speeding up Database Access' earlier. Now we are going to talk about Stored Procedures which provide another way of optimizing database access.
|
