dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: Measuring Stored Procedures against inline SQL

Hybrid View

  1. #1
    Join Date
    Aug 2006
    Location
    London
    Posts
    20

    Measuring Stored Procedures against inline SQL

    Hello,
    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
    Location
    St. Louis, MO, USA
    Posts
    1,582
    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
    Location
    London
    Posts
    20

    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



Recent Articles