Process Designer

We recommend the use of Prepared Statements because the database system used checks the validity of parameters before the SQL statement is processed. SQL injections can be effectively prevented by using Prepared Statements, which increases the security of your JobRouter Web Application.

Furthermore, Prepared Statements can, under certain circumstances, give you a performance advantage if you run the same SQL statement several times with different parameter values (for example, in a loop). This performance improvement is due to the fact that the SQL statement is already precompiled in the database system and is only executed with the new parameter values.