May 24, 2012

Post: MySQL Prepared Statements

…The great thing I love about Java MySQL API is it can switch between prepared and non-prepared statements transparently (in most cases). So …MySQL Prepared statements – many of the problems such as extra round trip, non working query cache or non working prepared statements for some of the statements

Post: New SpecJAppServer results at MySQL and Sun.

… does it mean MySQL did not scale well to 8 cores on this benchmark ? Now lets look at Java Settings: JDBC Pool… can also see Server prepared statements were disabled for the run (same as we had few years ago). Prepared statements generally should have helped this benchmark because it has a lot of same queries an Prepared Statements can be more…

Post: Alternatives of PHP ?

… mind. List of my requirements: – Stable binding to MySQL, support of new protocol with prepared statement is necessary. – good XML handling – Fast in… support MySQL narrows the list to Perl, Ruby, Java, C, C++, even Python supports only old mysql protocol (am I wrong here?). Excluding Java