Prepared Statement

Hi,

When iam using a prepared statement for executing a query which is being executed repeatedly, i need to know where is the prepared statement is stored temporarily, is it in the database or in the app server

Thanks in advance
NK

"nada76",
it appears that you had a valid display name and have changed it to an invalid display name. Please change it back immediately, since accounts with invalid display names get deleted.

thanks,
Dave.

PreparedStatements are supposed to 'coupled' with the compiled database statement, hence they should be cached in the database. While this is the typical behaviour, some database drivers 'fake' support for PreparedSatements by caching in the driver, or by not caching at all.

Dave

I have updated my profile. hope this suffice.

thanks for your reply

nk

Sorry, we require display names to be two words:
Your first name, a space, then your last name. Like it was originally.

Please update your profile.

thanks,
Dave