Home -> Usenet -> comp.databases.oracle -> Binding vs. not binding in dynamic sql.

Binding vs. not binding in dynamic sql.

From: Ward Mullins <ward_at_crl.com>
Date: 1995/04/09
Message-ID: <3ma2eu$7su_at_crl.crl.com>#1/1 






I was wondering if anyone has done any actual benchmarking on the 
performance hit of not binding variables in a dynamic sql (i.e. using an 
sprintf function to fill in data explicitly) vs binding variables for the 
sql.  I would imagine there is a parse overhead, and that oracle does 
some sort of caching of previously executed sql statements which would 
impact the performance, but I don't have a real feel for how much impact 
this is.  I would appreciated hearing from anyone who has benchmarked 
this, or might have some insight for me.



Thanks,


ward
Received on Sun Apr 09 1995 - 00:00:00 CEST












Original text of this message