Query Bindings

[eluser]happs74[/eluser]
Hi,

Quick question, I've done some stuff previously with coldfusion/oracle and I always used query bindings in any sql I wrote. The reasons was that I read that using them allowed oracle to preprocess/cache/precompile the query (i'm not sure what the proper terminology is). Can anyone tell me if this is done automagically at the db level, is it unique to oracle and does CI query binding do the same thing?

Ta.

[eluser]Negligence[/eluser]
They are called prepared statements, and no, using the binding feature in CI does not create prepared statements with true binding like you can do with the native PHP functions for Oracle. In basic terms, CI's binding does a string escape and replacement and nothing more.

[eluser]happs74[/eluser]
Cheers for the reply, i kinda expected that but thought I'd ask, i spent last night racking my brain for 'prepared statements' but my recall just wasn't working. I blame beer.