Time spent for database select and record fetching during a form query?
Hi,
We have problems with some queries running slow when executed from Oracle Forms, while this slowness cannot be reproduced executing the same query directly in database (from TOAD).
Trying to diagnose this, i added some logging into Forms, and the results are like that:
21.11.2018 12:17:33.064043 pre-query
21.11.2018 12:17:54.367740 post-select
21.11.2018 12:20:47.738896 post-query, recno=1
As far as my understanding has been:
- a) the time difference between lines 1 and 2 (21 sec) should correspond to the actual database query (this is roughly consistent with the time of executing the query in TOAD);
- b) the time difference between lines 2 and 3 (almost 3 min) should correspond to fetching resulting records from database to Forms?