MySQL Performance: MySQL => prepared statements in MySQL

Members

Help

Home

Home » Performance » MySQL » prepared statements in MySQL

Show: Today's Messages :: Show Polls :: Message Navigator

prepared statements in MySQL [message #1959]

Fri, 28 September 2007 15:02

mikec
Messages: 22
Registered: September 2007

Junior Member

Is there any advantage to using prepared statements in Java for DML in the following
scenario:

get a connection, prepare a statement, substitute the variable value, execute, close the
statement - repeat this process over and over.

Don’t you need to not close so that you don’t have to re-prepare the statement
in order to gain any performance advantage?

Report message to a moderator

Re: prepared statements in MySQL [message #1972 is a reply to message #1959 ]

Sun, 30 September 2007 20:16

sterin
Messages: 324
Registered: March 2007
Location: Sweden

Senior Member

That is correct, you need to hold the handle for the prepared statement and re-execute it with just different values each time.

prepare statement
LOOP:
  execute statement with different values
END:
close statement.

Report message to a moderator

Previous Topic:	MySQL Replication: Is it possible to ignore possible errors on slave?
Next Topic:	How can I create the database through query if the database name has blank spaces in it

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 20:08:34 EDT 2009

Total time taken to generate the page: 0.01084 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.