Can someone explain why we need prepared statements? I thought by using bind variables, we avoid the SQL parse time (at least with Oracle, that's my understanding) if you're using the same SQL but with different values in your bind variables.
Jade On Wed, Apr 16, 2008 at 7:00 PM, Dossy Shiobara <[EMAIL PROTECTED]> wrote: > In web applications, one of the big performance hits is SQL query parse > time. The irony is, in web applications, the queries aren't really > dynamic: most can be parsed once, and different bind variable values > used at execution time. > > -- Jade Rubick Senior Architect United eWay [EMAIL PROTECTED] tel (503)285-4963 fax (707)671-1333 www.UNITEDeWAY.org -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
