Profiling FairCom DB Application Performance

A core area to examine with FairCom DB application how much time is spent in each c-tree function. This provides areas of your application or even the FairCom Server for additional optimizations. 
 
To gather these statistics, run the following:
 
1. ctstat -wrktime on -u ADMIN -p ADMIN -s FAIRCOMS
where "FAIRCOMS" should be replaced with the name of your c-tree Server and appropriate credentials. This enables internal FairCom DB function call metrics. Note this impacts performance slightly and we only recommend doing this on a limited basis when needed.
 
2. ctstat -text -u ADMIN -p ADMIN -s FAIRCOMS  -i 60
This command will not return to the command line. It will log all c-tree Server statistics (including function call timings) to the text file SNAPSHOT.FCS every minute. We recommend capturing data for at least 10 minutes so as to have have several traces to analyze. To stop this execution, press ctrl-c to interrupt the program.
 
3. ctstat -wrktime off -u ADMIN -p ADMIN -s FAIRCOMS
Once the test in step 2 above is terminated, disable "wrktime" server metrics by making this call.
 
Please attach SNAPSHOT.FCS to a support ticket and we can help you analyze. Note SNAPSHOT.FCS is in clear text format so it's easily readable if you'd like to review yourself.

Example output
                   function name    count    elapsed average
                          LKISAM    14212    0.049    0.00000
                          DELREC       31    0.020    0.00066
                         DELVREC       31    0.001    0.00003
                          CLISAM        9    0.000    0.00004
                          CLSFIL       16    0.000    0.00000
                          ADDREC       58    0.002    0.00004
                          RWTREC       58    0.001    0.00002
                          NXTREC    50188    0.689    0.00001
                          FRSREC     1223    0.022    0.00001
                       GETALTSEQ       44    0.001    0.00002
                         EQLVREC    22187    0.184    0.00000
                         GTEVREC    15544    0.066    0.00000
                          GTVREC    12574    0.170    0.00001
                          GETSEG      440    0.001    0.00000
                          GETMAP      259    0.000    0.00000
                          EQLREC    12122    0.082    0.00000
                          GTEREC     6174    0.051    0.00000
                           GTREC       84    0.001    0.00001
                          CLIFIL      257    0.002    0.00001
                         OPNIFIL      319    0.006    0.00002
                         NXTVREC     8777    0.065    0.00000
                         FRSVREC       55    0.000    0.00001
                         INTISAM       11    0.001    0.00009
                         ADDVREC       73    0.003    0.00004
                         RWTVREC      865    0.020    0.00002
                         REDVREC      278    0.002    0.00000
                          DATENT      153    0.000    0.00000
                          IDXENT      166    0.000    0.00000
                          GETRES       20    0.000    0.00001
                         GETVLEN      278    0.001    0.00000
                        GETDODAX      132    0.001    0.00000
                         COMMBUF       18    0.000    0.00000
                       AVLFILNUM       20    0.000    0.00000
                          OPNFIL       20    0.000    0.00001
                      ctSNAPSHOT       68    0.047    0.00069