Subject interpreting IB_Monitor output
Author Markus Ostenried
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