SQL Server select statement, recordset object & stored procedure

Results 1 to 3 of 3

Thread: SQL Server select statement, recordset object & stored procedure

  1. #1
    Tom Murray Guest

    Default SQL Server select statement, recordset object & stored procedure

    I have a small, relatively static table (approx 20 rows X 4 fields). I would like to retrieve all of the information the table, formatting info from different fields different ways. I am currently doing this sending a SQL statement to the database and then using a recordset object to mainpulate the information in my ASP. However, it is very slow. I am thinking that I should use a stored procedure instead of sending my SQL statement to the database. How can I do this? Is it the right thing to do to improve performance?<BR>TIA, Tom

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: SQL Server select statement, recordset object & stored procedure

    Yeah, you can used a stored procedure. Stored procedures will improve your performance because they are precompiled. (See http://www.asptoday.com/articles/19990601.htm, it shows how one developer achieved roughly a 24% performance increase by using stored procedures)<BR><BR>Happy Programming!

  3. #3
    Tom Murray Guest

    Default Thanks!

    Scott, Thanks for your reply. I will check out the article. - Tom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •