Subject | RE: [IBO] Performance analisys |
---|---|
Author | Zile |
Post date | 2002-08-13T18:06:35Z |
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
information they are providing.
Have you looked at the IB_Profiler component ?
--
Geoff Worboys
Telesis Computing
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 canI am not familiar with IB Expert or EMS QuickDesk, so I dont know what
> see in IB Expert, or in EMS QuickDesk when you execute query. I use
> native IB components to access database.
information they are providing.
Have you looked at the IB_Profiler component ?
--
Geoff Worboys
Telesis Computing