Posted by NC on 11/16/07 20:36

On Nov 15, 10:05 pm, Lew <l...@lewscanon.com> wrote:
>
> 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?).

Performance problems with Linux / Tomcat / MySQL are very specific;
whatever the reasons, the response time of a Tomcat / MySQL setup
increases with the number of simultaneous connections much faster than
that of a PHP / MySQL setup.

Could there be solutions other than switching to PHP? Of course!
Here are a few possibilities:

1. Switching from JSP to Python.
2. Switching from MySQL to Oracle.
3. Switching from Tomcat to a commercial application
server.
4. Switching from Tomcat to JBOSS.
5. Investigating the root cause of the problem and fixing
it (which could possibly mean developing a new JDBC
driver for MySQL).

Options 2 and 3 entail significant license costs. Options 3 and 4 may
not solve the problem (if the problem is indeed in the JDBC driver,
changing the application server may not help). Option 5 has an
indefinite timeframe and highly uncertain cost, plus it requires
technical knowledge that the organization experiencing the problem may
not possess. What's left? Abandoning JSP altogether for something
that is known to work better with your chosen OS and DBMS...

Cheers,
NC

[Back to original message]