Subject | IB_Profiler |
---|---|
Author | |
Post date | 2014-11-27T17:22:04Z |
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
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