How to get execution times with TOraSQLMonitor like DBMonitor?

cis-wurzen · Post by **cis-wurzen** » Tue 04 Jan 2005 10:47

Well TOraSQLMonitor.OnSQL notifys me before opening a query but how I can determine the execution time?

Alex · Post by **Alex** » Wed 05 Jan 2005 10:03

TOraSQLMonitor doesn't give opprtunity for such measurements, you need to use DBMonitor tool. If you want determine execution time internally you can use After... and Before... events of your DataSet object.

Guest · Post by **Guest** » Wed 05 Jan 2005 11:03

It is impossible to add Before... and After... events by hand (or build a tool for that) in the full source which is nearly one million lines.

How can you measure it in DBMonitor?

Alex · Post by **Alex** » Wed 05 Jan 2005 14:58

"Duration" column in DBMonitor main window corresponds event duration time, so you can use this value.

cis-wurzen · Post by **cis-wurzen** » Wed 05 Jan 2005 16:45

I wanted to know how you are able to measure the times in DBMonitor from my application.
I had at look into the source and now I know how you can measure it.

Can you create an OnGetIDBMonitor event or create the events OnEvent and OnExecute(FDBMonitor.OnExecute and not TCustomDASQLMonitor.OnExecute ) in TCustomDASQLMonitor?

Alex · Post by **Alex** » Thu 06 Jan 2005 15:21

Sorry, but we are not going to extend TCustomDASQLMonitor functionality in the near future.