Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 25th, 2006, 05:30 PM
Friend of Wrox
 
Join Date: May 2005
Location: , , .
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default stored procedure

Is it a good practice to use many stored procedures instead of putting code directly in the page?

 
Old May 25th, 2006, 08:54 PM
Friend of Wrox
 
Join Date: May 2006
Location: San Diego, CA, USA.
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It can be, but there are reasons to do both, and arguments can be made that support both. Sometimes a stored proc will be faster, or provide better security, or hide complextity from the web developer, or improve scalability.

Another choice is to write a "business" layer, or data access layer, or both to make a more logical design. These layers are often written in some code that can be compiled, like a VB COM+ dll, or C++ COM+ dll.

Overall, though, it really depends on how complex your application is. For a simple dynamic website that doesn't get much traffic, and isn't dealing with lots of data that needs to be kept secure, it won't make much difference, if any. One common approach is to do the simplest thing that works, and revisit it later if or when needed.

This is a complicated topic with many things to consider.

Have fun

Woody Z http://www.learntoprogramnow.com
 
Old May 26th, 2006, 01:16 AM
Friend of Wrox
 
Join Date: May 2005
Location: , , .
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks woodyZ.you are an expert





Similar Threads
Thread Thread Starter Forum Replies Last Post
stored procedure prashant_telkar SQL Server 2000 1 July 9th, 2007 07:57 AM
Stored Procedure jezywrap SQL Server ASP 1 January 3rd, 2007 12:29 AM
stored procedure kdm260 SQL Server 2000 2 June 19th, 2006 04:45 PM
Stored Procedure rajanikrishna SQL Server 2000 0 July 18th, 2005 05:01 AM
Help About Stored Procedure zhuge6 BOOK: ASP.NET Website Programming Problem-Design-Solution 3 May 20th, 2005 09:27 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.