@Vladimir but if 1202+ has become smarter than 1102 and reuse prepared statements more often how come Thomas experience the 1207 to be magnitudes slower?
Shouldn't it be the other way around?
Med venlig hilsen / Kind regards,
Christian Bjørnbak
Chefudvikler / Lead Developer TouristOnline A/S Islands Brygge 43 2300 København S Denmark TLF: +45 32888230 Dir. TLF: +45 32888235
The difference is as follows: 1202 can cache across statement.close() calls. 1201 can't do that.
In other words, to use server-prepared statements in previous versions, you had to reuse the *same* PreparedStatement *object* again and again. As soon as you issue .close() you lose your shiny server-prepared statement.
Typical applications are written in a form of PreparedStatement ps = con.prepareStatement(sql); ps.excuteQuery(); ps.close();
In other words, almost always developers just recreate PreparedStatement and close it. The improvement of 1202 was to identify such patterns and use server-prepared statement in such cases as well. Vladimir