Subject | interpreting IB_Monitor output |
---|---|
Author | Markus Ostenried |
Post date | 2004-11-16T05:27:35Z |
Hi all,
I'm investing why one of my forms takes so long to open. With IB_Monitor
and the Profile option enabled I get this output when opening my form:
/*===
[ 16.11.2004 06:01:55 ]
//>>> STATEMENT PREPARED <<<//
TIB_Statement.API_Prepare()
TIB_Query: "W_DM_TermCli.Q_Term" stHandle=78649156
====*/
/*---
[ 16.11.2004 06:02:04 ]
DATABASE INFO
DB_HANDLE = 3633652
----*/
Looking at the timestamps: does this query really take 9 seconds to *prepare*?
When testing the statement in the query editor preparing is much faster.
Although actually fetching the records takes about 9 seconds.
The first timestamp in the whole output is 16.11.2004 06:01:53, the last is
16.11.2004 06:02:07. This leads me to the conclusion that the main time is
spent in the above output snippet, namely the preparing, right?
TIA,
Markus
I'm investing why one of my forms takes so long to open. With IB_Monitor
and the Profile option enabled I get this output when opening my form:
/*===
[ 16.11.2004 06:01:55 ]
//>>> STATEMENT PREPARED <<<//
TIB_Statement.API_Prepare()
TIB_Query: "W_DM_TermCli.Q_Term" stHandle=78649156
====*/
/*---
[ 16.11.2004 06:02:04 ]
DATABASE INFO
DB_HANDLE = 3633652
----*/
Looking at the timestamps: does this query really take 9 seconds to *prepare*?
When testing the statement in the query editor preparing is much faster.
Although actually fetching the records takes about 9 seconds.
The first timestamp in the whole output is 16.11.2004 06:01:53, the last is
16.11.2004 06:02:07. This leads me to the conclusion that the main time is
spent in the above output snippet, namely the preparing, right?
TIA,
Markus