There are three ways we are contemplating.



1.) Querying: passing in a open connection string and SQL statement to a COM

object, which passes back the open record set.

    Inserting: Not sure 

    Updating, and Deleting: passing in a open connection string and SQL

statement to a COM object, which executes the        statement and passes

back an error message or success.



2.) Do all the SQL statements on the ASP page

3.) Use Stored Procedures to process the SQL.



What are some of your thoughts on these methods?  What have you found to be

the fastest?



Thanks 

SQL Server Stored Procedures









----- Original Message -----

From: "James Kenney" <JEK@m...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, November 29, 2001 7:24 AM

Subject: [asp_databases] What is the fastest way to perform DB manipulation?





>

> There are three ways we are contemplating.

>

> 1.) Querying: passing in a open connection string and SQL statement to a

COM

> object, which passes back the open record set.

>     Inserting: Not sure

>     Updating, and Deleting: passing in a open connection string and SQL

> statement to a COM object, which executes the        statement and passes

> back an error message or success.

>

> 2.) Do all the SQL statements on the ASP page

> 3.) Use Stored Procedures to process the SQL.

>

> What are some of your thoughts on these methods?  What have you found to

be

> the fastest?

>

> Thanks

>

>




$subst('Email.Unsub')

>

> Read the future with ebooks at B&N

>

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks

>