Hi,
The problem I am getting is that because the populateUser calls SQL without bind
variables, almost half my shared pool (in oracle)
is filling up with these statements.
Can you think of any way around this.
Gareth
>
> Hi,
>
> I'm trying to performance tune my application, and am finding
> database performace my biggest problem. I am using Turbine to handle
> all my security, and I notice that the sql produced by the
> UserPeer (and I assume all SQL generated by Peers) doesn't
> use and kind
> prepared statement. I understand that the SQL in Peers is
> being generated on the fly, but requests like SELECT * WHERE
> USER_ID = ?
> could easily be anticipated!??
>
> Comments?
>
> Gareth
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
