RE: [sqr-users] actual execution time for select to process

["franck\.masson2002" <franck.masson2002@laposte.net>]

if you need only the cpu time and not cpu time + data transfert

     let $start_table = datetostr(datenow(), 'DD-MON-YYYY HH24:MI:SS')
     let #first=1
     begin-select
       if #first = 1
         let #first=0
         let $end_table = datetostr(datenow(), 'DD-MON-YYYY HH24:MI:SS')
         let #elapsed_table = round(datediff(strtodate($end_table,'DD-MON-YYYY 
HH24:MI:SS'), strtodate($start_table, 'DD-MON-YYYY HH24:MI:SS'), 'second'), 0)

       end-if
    ...
    end-select


If you are running on oracle or ODBC look to the option -B on the command line 
or with the Begin Select

franck,

> right .... if I:
>
>     let $start_table = datetostr(datenow(), 'DD-MON-YYYY HH24:MI:SS')
>     begin-select
>     ...
>     end-select
>     let $end_table = datetostr(datenow(), 'DD-MON-YYYY HH24:MI:SS')
>     let #elapsed_table = round(datediff(strtodate($end_table,
> 'DD-MON-YYYY HH24:MI:SS'),
>                                  strtodate($start_table, 'DD-MON-YYYY
> HH24:MI:SS'), 'second'), 0)
>
>
> then #elapsed_table contains the elapsed system time  ....  that is
> not what I want
>
> I want the query execution CPU time .... I do not have access to the
> database logs .... is there no way I can get that information though
> my program?
>
> Is there a way to set "something" on so that I can get a trace of the
> database log in my logsqr file?
>
> I ultimately want to print that CPU time as part of my output report.
>
> --wb
>
>
> At 08:51 PM 4/5/2007, you wrote:
> >Datenow() sqr function will retur the time.
> >Why do you say "I can grab system time before & after the select
> >statement and find the difference"
> >That's the elapsed time of the select.  If you want the query
> >execution CPU time you would need to look at the database logs.
> >Steve.
> >
> >-----Original Message-----
> >From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
> >[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]
> >On Behalf Of Wendy Biggs
> >Sent: Friday, 6 April 2007 6:59 AM
> >To: sqr-users@sqrug.org
> >Subject: [sqr-users] actual execution time for select to process
> >
> >I need to determine the actual execution time of several different
> >select statements.
> >Has anyone else on this list done this?
> >Is there an sqr variable that will get to that information?
> >
> >I can grab system time before & after the select statement and find
> >the difference ... but that is not the same as the actual time
> >the statement took to execute.
> >
> >Any and all help will be appreciated.
> >
> ><sigh>
> >--wb
> >
> >
> >
> >_______________________________________________
> >sqr-users mailing list
> >sqr-users@sqrug.org
> >http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> >
> >
> >_______________________________________________
> >sqr-users mailing list
> >sqr-users@sqrug.org
> >http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

Créez votre adresse électronique prenom.nom@laposte.net
1 Go d'espace de stockage, anti-spam et anti-virus intégrés.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users