Subject | RE: [IBO] TIB_Profile |
---|---|
Author | IBO Support List |
Post date | 2015-01-01T17:56:11Z |
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Thursday, November 27, 2014 10:33 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] TIB_Profile
Hi,
the
profile reports in the actual ibo version 5.5X are different to the
results in IBO 4.6.
My Test-Program: (Database: Firebird
2.1)
profiler.mark;
query.open; // select * from
artikel
profiler.Report('test',true)
the result is: (I can't see the
reads from the actual query)
PROFILE DIFF REPORT
*** OVERALL SERVER
PROCESS ***
Current Memory = 1.432.616 (+295.736)
Max Memory
= 2.358.024 (+32.528)
Num Buffer Reads = 309.664 (+176.429)
Num Buffer Writes = 10 (+1)
Num Page Reads = 21.165
(+17.079)
Num Page Writes = 10 (+1)
*** SEQUENTIAL (NON-INDEXED)
READS *** 19.133.440
10.682.368
RDB$RELATION_CONSTRAINTS
8.285.952 RELATION_ID=21528
78.080 RDB$FIELDS
87.040 MON$ATTACHMENTS
*** INDEXED
READS *** 5.832.704
327.680 RDB$INDICES
720.896 RDB$SECURITY_CLASSES
1.703.936
RDB$CHECK_CONSTRAINTS
1.900.544 RDB$CHARACTER_SETS
1.769.472 RDB$LOG_FILES
65.536 RDB$EXCEPTIONS
PROFILE
DATA MARKED AS START
In IBO 4.6
the result is:
PROFILE MARKED
START
PROFILE DIFF REPORT
*** OVERALL SERVER PROCESS ***
Num
Buffer Reads = 209.887 (+28.209)
Num Page Reads = 29.762
(+2.522)
*** SEQUENTIAL (NON-INDEXED) READS *** 10.242
10.242 ARTIKEL
PROFILE DATA MARKED AS START
Is there a
Workaround to activate this in
IBO5?
Thanks
Michael