Query performance monitoring
Posted in 1998
Pete Smith — — source: Informix-list mailing list archive (1991-1998)
Hi all, I am currently trynig to determine a means of monitoring the performance of individual queries within ESQL/C programs. Does anyone know how I might best approach this? Are there any tools/utilities which might be incorporated into the code? Also, can Informix store query timings for later examination? If so, how? Is there anything in the sqlca or sqlda structures that can be used for this? The qureies of interest are of sub-second duration, but we need to know as accurately as possible what the acual timing is. Informix is 7.20.UC3 Kit is HPUX 10.20 Thanks in advance for any suggestions Pete