• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Prepared Statement

 
Natesh Kurup
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Natesh Kurup
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have updated my profile. hope this suffice.

thanks for your reply

nk
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic