If a call to the API takes over one tenth of a second it will display and
output of the time the call took. If there is no time output consider that
the call was virtually instantaneous.

You probably just need to enable the Rows information in the output options
and then you will see all the fetches.

Jason Wharton

> -----Original Message-----
> From: Markus Ostenried [mailto:chef_007@...]
> Sent: Monday, November 15, 2004 10:28 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] interpreting IB_Monitor output
>
>
>
> 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
>