<div>
Depends on how much data you are processing. How much time ASP is taking and how much the stored procedure will take. <br />
<br />
I would say go ahead and compare the timings, whosoever the timings is less go with that. User should get the data as soon as possible.
</div>


Depends on how much data you are processing. How much time ASP is taking and how much the stored procedure will take.

I would say go ahead and compare the timings, whosoever the timings is less go with that. User should get the data as soon as possible.

<div>
It would take long hours to created the stored procedures and an asp to call them. This is why I am asking before we make such effort
</div>


It would take long hours to created the stored procedures and an asp to call them. This is why I am asking before we make such effort

<div>
In that case I would say dont touch anything. Lets go with what ever is there. If we go ahead with SP then we also have to do a detailed level of unit testing and there is risk of injecting a bug in the existing environment. So lets go ahead with the current ASP code.
</div>


In that case I would say dont touch anything. Lets go with what ever is there. If we go ahead with SP then we also have to do a detailed level of unit testing and there is risk of injecting a bug in the existing environment. So lets go ahead with the current ASP code.

<div>
Creating one stored procedures that returns 20 recordsets sounds the easiest solution and will be much easier to debug. &nbsp;Thanks.
</div>


Creating one stored procedures that returns 20 recordsets sounds the easiest solution and will be much easier to debug.  Thanks.

<div>
<div class="content wysiwyg-content">
I have an ASP page that has about 20 recordsets. Each recordset returns a maximum of 10 records, some only return one. <br />
Would the ASP run faster if the code to return the records is in the ASP page or would it be faster if I create stored procedures that then the ASP would call to create the recordsets and return the records?<br />
<br />
I am using ASP classic and MS SQL 2012 R2
</div>
</div>


I have an ASP page that has about 20 recordsets. Each recordset returns a maximum of 10 records, some only return one. 
Would the ASP run faster if the code to return the records is in the ASP page or would it be faster if I create stored procedures that then the ASP would call to create the recordsets and return the records?

I am using ASP classic and MS SQL 2012 R2

Recordset in ASP or Stored Procedure?

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.

Web Applications

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.