I have build a report which has two dataproviders. When I run it it takes a very long time to refresh. Most of the time it looks like nothing happens (no messages in status bar) and I’m looking at an hourglass. Is this the time that the query is running? The report is quit complex, I would like to know which part of the time of refresh is query-time and which part report-calculation/formatting time. So I know if I should make the report less complex or the query. Is it correct that when in status-bar messages appear like ‘rows’ counting etc. the query is finished?
As long as it’s not written “Computing data” at the bottom left of your window the query is still running on the server.
If it takes time to come at that point you have to optimize your query for your DB
Ofcourse you can check the “Data Manager” definition tab to see how long each query takes. Subtract this time from the total refresh time and you have the “formatting” time as a result.
Another possibility is to take the SQLs and time it in a another SQL tool (like Query Analyzer or in your case TOAD or SQL Plus).
(BOB member since 2004-08-24)
(BOB member since 2004-12-29)
(BOB member since 2002-06-25)
TOAD or SQL Plus).
]