/*******************************************************************************\ PerformanceMonitor.inc Description: Provides Support for running performance Monitoring Date Ver Who Description ------------------------------------------------------------------------------ 08/25/2008 1.0 Doug Creation \*******************************************************************************/ string strPerfMonFolder = "" Skip skPerfStack = createString() Skip skPerfHits = createString() Skip skPerfTime = createString() Stream stmPerfDetails = null Stream stmPerfTotals = null // Alias will be prepended and YYYY-MM-DD@hh;mm;ss.csv will be appended string strDefaultDetailsFileName = "PerfMon-Details-" string strDefaultTotalsFileName = "PerfMon-Totals-" DB PerfMon = create("Performance Monitoring",styleCentered) DBE PerfPath = field(PerfMon,"Folder to save performance logs in:", "C:\\Temp\\", 80) /**********************************************************************\ \**********************************************************************/ void PerfMonCloseButton(DB thedb) { release thedb hide thedb } /**********************************************************************\ \**********************************************************************/ void PerfMonStart(string strDetails, string strTotals) { string strDate = today "" string strDTime = dateOf(intOf(today)) "" if (null stmPerfDetails) { string strDT = strDate[(length(strDate)-4):] "-" strDTime[0:1] "-" strDTime[3:4] "@" strDTime[9:10] ";"strDTime[12:13]";" strDTime[15:16] stmPerfDetails = write(strPerfMonFolder strDetails strDT ".csv") stmPerfDetails << "\"ID\"" stmPerfDetails << "," stmPerfDetails << "\"Start (Milliseconds)\"" stmPerfDetails << "," stmPerfDetails << "\"Stop (Milliseconds)\"" stmPerfDetails << "," stmPerfDetails << "\"Total (Milliseconds)\"" stmPerfDetails << "\n" stmPerfTotals = write(strPerfMonFolder strTotals strDT ".csv") } } /**********************************************************************\ \**********************************************************************/ void PerfMonStart() { PerfMonStart(strDefaultDetailsFileName,strDefaultTotalsFileName ) } /**********************************************************************\ \**********************************************************************/ void PerfMonInitiate(DB thedb) { string strFolderPath = get PerfPath Stat s if (null strFolderPath) { ack "Please specify the folder you want the performance logs to be placed in." setFocus(PerfPath) return } if ( ((strFolderPath[(length(strFolderPath)-1):(length(strFolderPath)-1)]) == "/") || ((strFolderPath[(length(strFolderPath)-1):(length(strFolderPath)-1)]) == "\\") ) { s = create(strFolderPath[0:(length(strFolderPath)-2)]) } else { s = create(strFolderPath) } if (null s || !directory(s)) { ack "The folder " strFolderPath " does not exist." setFocus(PerfPath) return } if ( ((strFolderPath[(length(strFolderPath)-1):(length(strFolderPath)-1)]) != "/") && ((strFolderPath[(length(strFolderPath)-1):(length(strFolderPath)-1)]) != "\\") ) { strFolderPath = strFolderPath "\\" } strPerfMonFolder = strFolderPath PerfMonCloseButton(PerfMon) PerfMonStart() } /**********************************************************************\ \**********************************************************************/ void PerfRegisterStart(string strID) { if (! null stmPerfDetails) { put(skPerfStack,strID,(getTickCount_())) } } /**********************************************************************\ \**********************************************************************/ void PerfRegisterStop( string strID) { if (! null stmPerfDetails) { int iStart = 0 int iStop = (getTickCount_()) int iTime = 0 int iTotal = 0 int iHits = 0 if (find(skPerfStack,strID,iStart)) { iTotal = (iStop - iStart) stmPerfDetails << strID "" stmPerfDetails << "," stmPerfDetails << iStart "" stmPerfDetails << "," stmPerfDetails << iStop "" stmPerfDetails << "," stmPerfDetails << iTotal "" stmPerfDetails << "\n" delete(skPerfStack,strID) // Update Total Time if (find(skPerfTime,strID,iTime)) { iTime += iTotal delete(skPerfTime,strID) put(skPerfTime,strID,iTime) } else { put(skPerfTime,strID,iTotal) } // Update Total Hits if (find(skPerfHits,strID,iHits)) { iHits++ delete(skPerfHits,strID) put(skPerfHits,strID,iHits) } else { put(skPerfHits,strID,1) } } } } /**********************************************************************\ \**********************************************************************/ void PerfMonStop() { string strID = "" int iHits = 0 int iTime = 0 if (! null stmPerfDetails) { stmPerfDetails << "******** END ********\n" flush(stmPerfDetails) close(stmPerfDetails) stmPerfDetails = null } if (! null stmPerfTotals) { stmPerfTotals << "\"ID\"" stmPerfTotals << "," stmPerfTotals << "\"Hits\"" stmPerfTotals << "," stmPerfTotals << "\"Avg. Time (Milliseconds)\"" stmPerfTotals << "," stmPerfTotals << "\"Total Time (Milliseconds)\"" stmPerfTotals << "," stmPerfTotals << "\"Total Time (Seconds)\"" stmPerfTotals << "," stmPerfTotals << "\"Total Time (Minutes)\"" stmPerfTotals << "\n" for iHits in skPerfHits do { strID = (string key skPerfHits) stmPerfTotals << strID // Hits stmPerfTotals << "," stmPerfTotals << iHits "" if (find(skPerfTime, strID, iTime)) { // Average Time if (iTime>0) { stmPerfTotals << "," stmPerfTotals << (realOf(iTime)/realOf(iHits)) "" } else { stmPerfTotals << "," stmPerfTotals << "0" } // Total Time in Milliseconds stmPerfTotals << "," stmPerfTotals << iTime "" // Total Time in Seconds stmPerfTotals << "," stmPerfTotals << (realOf(iTime)/1000.0) "" // Total Time in Minutes stmPerfTotals << "," stmPerfTotals << ((realOf(iTime)/1000.0)/60.0) "" } stmPerfTotals << "\n" } flush(stmPerfTotals) close(stmPerfTotals) stmPerfTotals = null } // Empty all the Skips for iTime in skPerfStack do { strID = (string key skPerfStack) delete(skPerfStack,strID) } for iTime in skPerfHits do { strID = (string key skPerfHits) delete(skPerfHits,strID) } for iTime in skPerfTime do { strID = (string key skPerfTime) delete(skPerfTime,strID) } } ///// Start the Monitor? //StartButton = button(PerfMon,"Start Performance Monitoring",PerfMonInitiate) apply(PerfMon,"Start Performance Monitoring",PerfMonInitiate) close(PerfMon,false,PerfMonCloseButton) apply(PerfMon,"Cancel",PerfMonCloseButton) realize(PerfMon) block PerfMon ) realize(PerfMon)