On Fri, Nov 26, 1999 at 03:23:19PM -0500, Mike McCauley wrote:
> Hi Jeremy,
>
> On Nov 26, 12:02pm, Jeremy Burton wrote:
> > Subject: (RADIATOR) Parameter Binding for AuthBy SQL?
> > Hi All,
> > Just wondering if there has been any thoughts about doing any sort of
> > parameter binding
> > (ie prepare("SELECT account_type FROM clients WHERE username = ?");
> > execute($username);)
> > for AuthBy SQL. I was doing some performance tuning work on our Oracle
> > Database yesterday, and the reparsing of our Auth statements is causing a
> > bit of a performance hit. Not a problem for us at the moment, but it could
> > be down the track somewhere.
>
>
> Yes, we have thought about it.
> Unfortunately, not all DBD modules support parameter binding. Oracle does as
> you say, and it can significantly improve performance. I think until we see a
> few more DBD's supporting it, we probably wont add it.
How hard would it be to include both styles perhaps, and then allow people
to make the choice? I feel that particularly for larger installations, this
would be an important consideration..
Jeremy
--
Jeremy Burton
Database Administrator, Netspace Online Systems
[EMAIL PROTECTED]
[EMAIL PROTECTED], [EMAIL PROTECTED]
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
