Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Unanswered: statistics time in Sybase

    Hi!
    Can anyone please help me to get the vaules of 'statistics time on' utility.i want to measure the performance of my any normal query to Sybase database.I want to measure the SQL Execution time..Theres one set statistics time on utility..and it gives me the required parameters also...but i want to capture those parameters and send it back to my program.So please help me ow to get those parameters.
    thanks
    Amol

  2. #2
    Join Date
    Mar 2003
    Posts
    15
    Hi,

    If you just want time then you can do something like this


    select @starttime = getdate()

    your_query /*select, update, insert*/

    select @endtime = getdate()

    select @runtime = datediff(ms,@starttime,@endtime)
    this will give you diffrence in milliseconds
    db_mate

Posting Permissions

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