In the servoy-admin webpages of the Servoy Application Server there is section about Database Performance Statistics .
You will see a list of queries.
Is it normal to see a lot of questionmarks?
Like```
select count(dossier.dossier_id) from dossier where dossier.dossierparent_id = ?
select distinct dossier_id,dossiernummer from dossier where UPPER(dossiernummer) like ? order by dossiernummer
```Are the queries only queries caused by searches....or some of them created by the solution to present data on forms?
The question marks are variables. The qury could be run 100 times, but every time with different parameters.
By using the questionmarks, the query fired at the DB is always the same, so the performance is improved. Only the variable part of the query is different.
If you want to see the content of the question marks, you need to turn on trace and look at the Status Log. All the individual queries will show upo there, together witht he content of the questionmark variables.
All queries fired by the solution, except the ones towards the repository are listed in the Database Performance section