Assuming you're using stored procedures... Start procedure with logging current time, name of procedure,... Perform whatever must be performed End procedure with logging current time, name of procedure,... Query logging table to get time spent Alternative, still assuming you're using stored procedures... Start procedure with noting current time, name of procedure,... Perform whatever must be performed End procedure with logging current time - start time, name of procedure,... Query logging table to get time spent
>>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-03-06 14:37 >>> I preffer that the database give me this information. I don't know if it is possible becouse if we retrieve many rows and if we want to put this result in a new column the same time will be replicated many times and consuming more processing. Any other suggestion ? Ezequias 2007/3/6, Bart Degryse <[EMAIL PROTECTED]>: > > > note the time just before your operation starts > note the time just after it ends > show timeafter - timebefore > > >>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-03-06 > 14:20 >>> > > Hi list, > > It is possible to retrieve the time of a SQL statement leads to > execute ? I would like to put in my application how much time each > operation leads to finish. > > Any suggestion ? > > -- > Ezequias Rodrigues da Rocha > http://ezequiasrocha.blogspot.com/ > use Mozilla Firefox:http://br.mozdev.org/firefox/ > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http://br.mozdev.org/firefox/
