PlugIns JdbcSlim UserGuide 6OutputOptions
If you just want to see the row count of the recordset set the flag dbOnlyRowCount to the name of the column which should show the row count.
In this case you might want to measure performance. To do so set also one or all of the following:
dbPerf - Total processing time in seconds
dbPerfRetrieval - Time to get all rows and columns from the recordset from the database server into the application server
dbPerfExecution - Time to execute the statement on the database server
| SQLCommand | TestDatabase | select d1.*, d2.*, d3.*, d4.*, d5.* from TestData d1 join TestData d2 join TestData d3 join TestData d4 join TestData d5 | dbOnlyRowCount=RowCount dbPerf=ProcessingTime dbPerfRetrieval=RetrievalTime dbPerfExecution=ExecutionTime |
| RowCount? | ProcessingTime? | RetrievalTime? | ExecutionTime? |
| 32768 | <1 | <1 | <1 |
| SQLCommand | TestDatabase | %SQL% | dbOnlyRowCount=RowCount dbPerf=ProcessingTime dbPerfRetrieval=RetrievalTime dbPerfExecution=ExecutionTime | |
| SQL | RowCount? | ProcessingTime? | RetrievalTime? | ExecutionTime? |
| select d1.*, d2.*, d3.* from TestData d1 join TestData d2 join TestData d3 | 512 | <1 | <1 | <1 |
| select d1.*, d2.*, d3.*, d4.* from TestData d1 join TestData d2 join TestData d3 join TestData d4 | 4096 | <1 | <1 | <1 |
| select d1.*, d2.*, d3.*, d4.*, d5.* from TestData d1 join TestData d2 join TestData d3 join TestData d4 join TestData d5 | 32768 | <5 | <5 | <5 |