Subject | Performance analisys |
---|---|
Author | Zile |
Post date | 2002-08-16T21:04:50Z |
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
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