Page 1 of 1
How to get execution times with TOraSQLMonitor like DBMonitor?
Posted: Tue 04 Jan 2005 10:47
by cis-wurzen
Well TOraSQLMonitor.OnSQL notifys me before opening a query but how I can determine the execution time?
Posted: Wed 05 Jan 2005 10:03
by Alex
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.
Posted: Wed 05 Jan 2005 11:03
by Guest
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?
Posted: Wed 05 Jan 2005 14:58
by Alex
"Duration" column in DBMonitor main window corresponds event duration time, so you can use this value.
Posted: Wed 05 Jan 2005 16:45
by cis-wurzen
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?
Posted: Thu 06 Jan 2005 15:21
by Alex
Sorry, but we are not going to extend TCustomDASQLMonitor functionality in the near future.