On Fri, Nov 26, 1999 at 02:59:42PM +1100, Hugh Irvine wrote:
>
> 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.
I already do this, however I reparsing this statement is what is happening-
it would be nice if i could go
select check_items(?, ?,?), reply_items(?, ?, ?) from clients where
username=?
and then bind this...
--
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.
