Results 1 to 3 of 3

Thread: Measuring Stored Procedures against inline SQL

  1. #1
    Join Date
    Aug 2006

    Measuring Stored Procedures against inline SQL

    We run a fairly complex website using classic ASP. We are going to be moving our SQL Queries over to Stored procedures from the traditional code inline method.

    What we need is a way of measuring the speed of both methods to see the level of query time saved (if any) when using Stored Procedures.

    Any ideas would be appreciated.

  2. #2
    Join Date
    Dec 2002
    St. Louis, MO, USA
    It's been a while since I've used Classic ASP (much, MUCH preferred over .NET), so I really don't remember if Classic ASP has an equivalent to ColdFusions getTickCount() function (grabs the number of milliseconds that have passed since 00:00:00.000 Jan 1, 1970.)

    If it does, then you can use that to time all the inline queries; then do the same thing with Stored Procedures.

    Get milliseconds; run query; get milliseconds; calculate difference.

    Get milliseconds; run SP; get milliseconds; calculate difference.


  3. #3
    Join Date
    Aug 2006

    Thumbs up Thanks

    Thanks WolfShade,

    That makes sense, so I'm going to have to run both types of query from the web page to get an accurate A-B test.

    I'll run two functions, one after the other, calculating the time difference between both.

    Very helpful, Thank you!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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