Subject RE: [IBO] TIB_Profile
Author IBO Support List
Hi Michael,
 
Sorry for the delay in responding to this issue.
 
What I am wondering is if there are some additional schema cache queries that are being performed that are skewing the results.
 
Have you looked at what is going on with the SQL trace monitor to compare?
 
I'm not sure what all I can do in order to help you withoug additional information.
 
Thanks,
Jason Wharton
 


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