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.
Cheers.
>
>
> 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.
>-- End of excerpt from Jeremy Burton
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
