home navigator pointer resources navigator pointer asp tips navigator pointer sql stored procedures
The definitive ASP tips page
tips menu | printable single page version

Note: this is my old ASP tips page and is no longer supported. See the new Visualize web site..

ASP Coding for Performance - Use SQL Stored Procedures

Rather than use pass-through SQL, consider setting up stored procedures to handle common queries. These are more efficient and robust than constructing and executing full SQL statements. Most database engines offer these facilities including DB2, ORACLE (can be combined with PL/SQL) and SQL Server.

 

DISCLAIMER: Note these pages are a free resource for anyone wishing to reference them. Although every care is taken to ensure their correctness, the author takes no responsibility for any errors or problems that may occur through their use, or indeed misuse. These pages are copyight of Dave Clarke, Visualize Software Ltd 1997-2000 (all rights reserved).

 


© Copyright Dave Clarke, 1996-2008