how mysql prepared matter caching?


how i take advantage mysql's ability cache prepared statements?
one reason prepared statements there need send prepared matter itself churned times same prepared matter used again.



class.forname("com.mysql.jdbc.driver");
connection conn = drivermanager.getconnection("jdbc:mysql://127.0.0.1:3306/mydb" +
"?cacheprepstmts=true", "user", "pass");
for (int i = 0; i < 5; i++) {
preparedstatement ps = conn.preparestatement("select * mytable where id=?");
ps.setint(1, 1);
ps.execute();
}
conn.close()


when controlling above java instance i 5 pairs prepared govern commands mysqld record file. relocating ps assignment outmost loop law unparalleled prepared 5 govern commands course. tie parameter "cacheprepstmts=true" doesn't seem any inadequacy here.

when controlling identical way controlling open hibernate array prepared commands sent (1 5) depends presumably cacheprepstmts tie parameter enabled. does hibernate govern prepared statements take advantage cacheprepstmts setting? illusory burlesque controlling pristine jdbc?

i controlling mysql server 4.1.22 mysql-connector-java-5.0.4.jar



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members