Client Performance

Overview

This page displays the client performance (if enabled) of each solution. It contains information about time (total, average, min, max, standard deviation), count, method name and location for each called method / solution. It helps developers to analyze if their application contains poorly-performing code.

Client Performance settings can be found Servoy Admin interface: <host-name>/servoy-admin/client-performance.

View performance grouped by solution

Statistics are grouped by solutions:

Statistics grouped by solution

In order to see statistics, click on the desired solution name.

View running methods

This shows the performance of ongoing call stacks (typically only problematic queries will be visible).

View past client statistics

Performance of "test" solution

After clicking on the solution name, the standard client statistics page will be shown, displaying a table with the following statistics:

• call count : the number of times that this method got called

• total time : this is the sum or running times for this method call (inlcides API calls to browser)

• average time : the average time it takes to execute this method

• action : method name, including its path

Average time and total count for each query are the most useful stats.

Advanced statistics

Performance of "test" solution - advanced statistics

When clicking on Show ADVANCED Performance Statistics., the table shows extra statistics:

• Total time inside calls : this is the sum or running times of calls initiated during all runs of this method

• Average time inside calls : this is the average of the sum of running times of API calls to browser initiated during all calls to this method

• Min Time : mininum time that one execution of this method took

• Min time inside calls : minimum of the sum of running times of API calls to browser initiated during all calls to this method

• Max Time : maximum time that one execution of this method took

• Max Time inside calls : maximum of the sum of running times of API calls to browser initiated during all calls to this method

• Standard Deviation : standard deviation of executions of this query; see standard deviation

• Standard Deviation inside calls : standard deviation of the sum of running times of calls initiated during all calls to this method; see standard deviation

• Standard Deviation / Average Time : standard deviation divided by average time

• Standard Deviation / Average Time inside calls : standard deviation inside calls divided by average time inside calls

Clear statistics

Statistics can be cleared for each solution, by clicking Clear Statistics..

Export

Statistics can be exported for each solution, by clicking Download as CSV..

Control Number of entries

The user can control the number of Performance entries by selecting one of the options available on top the Client Performance page in Servoy Admin:

• Disabled

• Log only (goes straight to log, ideal for production if you still want this data)

• 100 max

• Unlimited:

Warning: Not ideal for production systems as it can have a big footprint on the server.

---

Log Only

Servoy Provides special loggers that will log the performance directly to a file, this doesn't only work in Log Only (also for the admin page logging if that i enabled) For this you need to enhance the log4j.xml file that you use in production (or developer/application server if you want to test this in developer)

First in the loggers section of the log4x.xml file you need to add a Logger with the INFO level

        <Logger name="com.servoy.performance.timing.methods" level="INFO" additivity="false">
            <AppenderRef ref="asyncperformanceoutput" />
        </Logger>

the name is the logger where Servoy will output this to. It is a good thing to redirect this directly to its own file (and use additivity="false" to make sure it really only goes to that file) The Appender part is then creating its own output and uses async so the writing of the log is done in a seperate thread:

        <RollingFile name="performanceoutput"
            fileName="${log4j:configParentLocation}/performanceoutput.txt"
            filePattern="${log4j:configParentLocation}/performanceoutput-%i.txt.zip"
            immediateFlush="true" append="true">
            <Policies>
                <SizeBasedTriggeringPolicy size="10MB" />
            </Policies>
            <PatternLayout
                pattern="%d %m%n" />
        </RollingFile>
        <Async name="asyncperformanceoutput">
            <AppenderRef ref="performanceoutput" />
        </Async>

You can also add the sql timing directly to the same file if needed or output that also to another file:

        <Logger name="com.servoy.performance.timing.sql" level="INFO" additivity="false">
            <AppenderRef ref="asyncperformanceoutput" />
        </Logger>

NOTE ServoyCloud has far more advanced client monitoring features, including machine learning analyses and AI.