Do JSP & MYSQL make the processing slow on web pages?

Question

We developed a web based software having JSP as fron end and MYSQL as back end. When a large no. of users login on web the processing becomes very slow. Someone suggested that MYSQL as back end does not support JSP peoperly. If ASP is used with SQL it will work better.
Please tell me is it right?

Answer 1

On the contrary it runs very fast. Much faster than others.There must be some configuration problem.

Here are 3 preliminary suggestions
1> Run Mysql / Tomcat /Apache on Linux. I've never used it on windows. Though it should run equally fast on windows, I don't know about it.

2> Use database connection pool to connect to the database, and configure the pool carefully. Tomcat documentation tells u how to optimize it.

3>U may also have to increase the number concurrent connections MySql allows. Mysql Manual tells that. There r also 3 different sample configuration files for different types of load. Umay use the right one depending on ur requirement.


With in a short time I shall start my website to help in this type of problems. I like that. If u wish I can send u the URL as soon as I'm ready.
Goodluck

Answer 2

JSP and MySQL work very well together, in my experience--much faster than ASP with SQL Server. Chances are greatest that the HTTP server itself isn't allowing enough child processes to spawn to handle the requests, or that the server that it's on is simply too small.

If you're running JSP/Tomcat/IIS or JSP/Tomcat/Apache on Windows, this may be another part of your problem. Running Java web servers on Windows is usually a bad idea, and MySQL is similarly recommended to be used on other systems in a production environment.

Don't look at the language or the database, look at the server underneath and work from there.

Answer 3

of course the obtrusive answer is close someof the pages. each and each occupies a small component to memory and if there are startup bloatware being loaded the quantity usable is shrink down. visit MSConfig and in startup, clean out the unneeded classes. you additionally can go into equipment settings by way of administration Panel and verify cache allocation. confirm that's desperate to computerized. Do a disk cleanup and defrag for speedier get right of entry to, then as others will say, you are able to upload memory to have greater allocations area.