Hello Jeremy -
On Fri, 26 Nov 1999, Jeremy Burton wrote:
> 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.
>
This has been discussed on the list before, and the concensus of opinion seemed
to be that for maximum performance, an AuthSelect and/or AcctSQLStatement
calling an Oracle stored procedure was probably the go.
hth
Hugh
--
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.
