+ Reply to Thread
Results 1 to 4 of 4
  1. 08-16-2004 09:01 AM #1
    anuj
    anuj is offline Junior Member
    Join Date
    Aug 2001
    Posts
    56

    Angry How to retrieve elapsed time in milisecond using sql query

    Hi
    Can some one please send the suggestion, how to check the query time in miliseconds.

    Its Urgent!

    Many Thanks
    Anuj
    Anuj
    India
    Reply With Quote Reply With Quote
  2. 08-16-2004 09:10 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    Crystal ball broken today, please elaborate.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote
  3. 08-16-2004 09:17 AM #3
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline mod
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,841
    My crystal ball returned:


    set timing on
    Reply With Quote Reply With Quote
  4. 08-16-2004 09:22 AM #4
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Set timing on, tkprof, etc give you times to the centi-second. I doubt very much if a real-life query would have a execution time reproducible to better than that. So my advice is - don't bother.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width