Subject RE: [IBO] Performance analisys
Author Zile
I am not quite shure how to use IB_Profiler. I need information like this:

Query: "select * from malo inner join malo_st on
(malo.broj=malo_st.faktura)"

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
|
+--------------------------+-------+-----------+---------+---------+--------
-+


-----Original Message-----
From: Geoff Worboys [mailto:geoff@...]
Sent: Tuesday, August 13, 2002 01:48
To: Zile
Subject: Re: [IBO] Performance analisys


> Can someone help me to get performace informaton, like one you can
> see in IB Expert, or in EMS QuickDesk when you execute query. I use
> native IB components to access database.

I am not familiar with IB Expert or EMS QuickDesk, so I dont know what
information they are providing.

Have you looked at the IB_Profiler component ?

--
Geoff Worboys
Telesis Computing