Use the IB_Profile component.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Zile" <zilez@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Friday, August 16, 2002 2:04 PM
Subject: [IBO] Performance analisys


> I asked once, but didn't get answer. So, only once more, if I execute
> folowing query in IB Expert or EMS QuickDesktop:
> " select * from malo inner join malo_st on ( malo.broj = malo_st.faktura )
"
>
> I receive folowing information:
>
> Information:
> Query Time
> ------------------------------------------------
> Prepare : 5.00 ms
> Execute : 250.00 ms
> Avg fetch time: 25.00 ms
> ------------------------------------------------
> Memory
> ------------------------------------------------
> Current: 35,847,168
> Max : 35,980,376
> Buffers: 8,192
> ------------------------------------------------
> Operations
> ------------------------------------------------
> Read : 14
> Writes : 0
> Fetches: 72
> ------------------------------------------------
> Enchanced Info:
>
+--------------------------+-------+-----------+---------+---------+--------
> -+
> | Table Name | Index | Non-Index | Updates | Deletes |
Inserts
> |
> | | reads | reads | | |
> |
>
+--------------------------+-------+-----------+---------+---------+--------
> -+
> | MALO_ST| 14 | 0 | 0 | 0 |
0
> |
> | MALO| 0 | 6 | 0 | 0 |
0
> |
>
+--------------------------+-------+-----------+---------+---------+--------
> -+
> {this one is especialy interesting!!!}
>
> How can I get these datas if I use native IBO control.
>
> Thanks in advance
>
> Zile