|
|
Posted by Lew on 11/16/07 06:05
Jerry Stuckle wrote:
> Yes, but MySQL (and many other databases) access through the jdbc
> drivers is much slower than in PHP. The JDBC driver is often byte code
> and needs to be interpreted. OTOH, the PHP driver is compiled C, and
> uses the C calls to the database, which are generally faster.
First of all, bytecode interpretation is a fraction of the overhead of talking
to a database.
Secondly, all production-grade JVMs optimize the heck out of bytecode to a
degree at least comparable to C code.
Do you have citations for the differences in Java MySQL speed and PHP MySQL speed?
Do you have citations for the reasons for any differences?
I am still interested - do you have citations for performance differences
between the Java / MySQL combination and other Java / RDBMS combinations like
Postgres or Oracle?
I hear the conclusions that have been stated:
- Java / Tomcat to MySQL is slower than other Java / RDBMS combinations.
- Java / Oracle works better than Java / Tomcat / MySQL.
- There were severe performance problems (unspecified) with Linux / Tomcat /
MySQL.
- These problems necessitated a switch to PHP (implying no other solution
would have worked?).
- Java / Tomcat to MySQL is slower than PHP / Apache / MySQL.
- This latter is due to bytecode interpretation being slower than C binary
execution.
- C calls to MySQL are generally faster than JDBC calls to MySQL.
One at least is incorrect. I am interested in the evidence for the others.
--
Lew
Navigation:
[Reply to this message]
|