Response from Tomcat Server slow and Invariable to JSP

[jason.3dmagic]

Hello,

I have developed an application which is an INTRANET PORTAL in advanced java. My database is MySQL and Server is Tomcat V5.5

The problem is server response is very slow and sometimes it stops responding, also when I try accessing it from remote machine I don't get response from my server.

Please help...

Thank and Regards

[r035198x]

Find a profiling tool and try to pin point the source of the problem.

[jason.3dmagic]

Please Clarify the profiling tool :confused:

I have developed my application in java Eclipse, using MySQL Database and TOMCAT 5.5 Server

[r035198x]

You'll have to google for it. We can't see any of your codes so we can't say if it's your code that is the problem or perhaps your database is not well indexed, non optimal SQL, connections left unclosed e.t.c.

[jason.3dmagic]

I am a college student, I don't know how to structure the database efficiently
and also the indexing and optimization of SQL

I am giving you the project theme::

It maintains all the information of employees and students, like leave and salaries under which authority the employee or under which the student belongs. Also daily attendance of all, basic finance related issues.

Also when I try to access my application from remote server it don't work. It was used to work before. Dont know wats the problem is

:confused::confused::confused:

Thanks and Regards

[RamyaSivakanth]

how u have desined the database? how many records are there?
how u are connecting to remote server?

[r035198x]

Read the relevant sections in the MySQL ref manual for making efficient database queries and indexes.
For the remote connection, you will need to provide details on how you are miking the connection and the error messages you are getting.

[jason.3dmagic]

Yes I have designed the database....

I am not using indexing techniques

I am using following code for database connection

Class.forName("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection("jdbc:mysql://localhost/magicnet?user=isf&password=isf123");


Is der any other efficient way for connection to the database?
:confused:

TO connect to remote server I copy the war file to webapps folder of TOMCAT, then I start the server and write URL into the browser...

[r035198x]

You can use a datasource. Also make sure you closed all connections in a finally block. Read the MySQL refmanual like I already suggested to find out how to tune your tables for efficiency.
You don't move the war file to all computers that want to connect to the system. See in that path you have localhost as the database host and the client computers will not be having MySQL installed on them. They shouldn't even have Tomcat on them.
Keep your war file on the one computer that contains tomcat and make sure to provide the right connection string.

[ideyatech]

I found this page and it helped me speed up my server.

Here's the link.