SideBar
User Login 3-3:reusing_prepared_statements
last edited by
gef
on 03-Oct-2011
gef
on 03-Oct-2011
Prepared statements are generated by a database in order to speed up recurring queries. The execution plan generated upon first call will be reused. Prior to Railo 3.3 using the tag CFQUERY with CFQUERYPARAM generated prepared statements, but the statements never survived one single request.
Now in Railo 3.3 within the same connection Railo will reuse all the prepared statements even across requests. This should result in an improved execution time, when several prepared statements ( queries with CFQUERYPARAM) are used.
