Hide section header if there's nothing to show
for exemple
hide "* SELECTED COLUMNS"
if there's no selected columns to show.

PS : it happens with native queries for example

During test generation, QuickPerf live generates a file containing the expected response body.

WIth REST API, the generated response body has a JSON format. The issue aims at formating the JSON.

The code to add is around here.

This issue aims to display a warning if the SQL execution number is greater than a configured threshold.

A quickperf.database.sql.execution.detected boolean property will enable the detection.

A quickperf.database.sql.execution.threshold number property will allow configuring the threshold value.

The configuration could be displayed and updated after the application startup with the help of MBeans:

QuickPerf
  -- Database
      -- Operations
           -- boolean isSqlExecutionDetected()
           -- void setSqlExecutionDetected(boolean)
           -- int getSqlExecutionThreshold()
           -- void setSqlExecutionThreshold(int)

Today, QuickPerf live works with Spring Boot and HTTP calls.

We may implement QuickPerf live features for Spring Batch.

We might display the INFO and WARNING reports at Spring Batch step level.

To discuss...

We may start with migrating one feature, for example the N+1 select detection.

Display the exluded URLs on the standard output at startup

cc @debbeca

Bind parameters are an essential feature to prevent SQL injections and can help improve performance (https://blogs.oracle.com/sql/improve-sql-query-performance-by-using-bind-variables, https://use-the-index-luke.com/sql/where-clause/bind-parameters, https://dzone.com/articles/why-sql-bind-variables-are-important-for-performan).

QuickPerf live could display a warning message in case of SQL queries without bind parameters. For example, QuickPerf live would raise a warning with the SELECT col1 FROM table where col2 ='VALUE' query but not with the SELECT col1 FROM table where col2 = ? query.

quickperf.database.sql.without-bind-param.detected boolean property will enable the detection of SQL queries without bind parameters.

The configuration could be displayed and updated after the application startup with the help of MBeans:

QuickPerf
  -- Database
      -- Operations
           -- boolean isQueryWithoutBindParamDetected()
           -- void setQueryWithoutBindParamDetected(boolean)

This issue aims to be able to configure more the database connection profiling:

• the profiling level
• turn on / turn off stack trace display
• the stack length

We should have the ability to do the configuration with properties and display/update it with MBeans.

👉 Code entry

Don't hesitate to ask if you have any questions.

For some reason, we don't need to perform quick perf on some endpoints.
like actuator endpoints.
it would be great to filter the /manage/* urls for example

Today, QuickPerf live can generate JUnit 4 and JUnit 5 tests. These tests check the non-regression on functional behavior together with the non-regression on N+1 select.

This issue aims to generate Karate tests to ensure non-regression on functional behavior.