Improve the performance of Java Web Application -

-

I am working with a 3-level web application that has the following technology stack:

  • Service 3.0 3.0
  • JSP 2.4
  • Spring 3.0
  • MySQL Database
  • Tommak Web Server < / Li>

We launch this application using the Mozilla Firefox browser. My problem is that, while having large data on the database, the application is facing the problem.

We have about 10 JSPs while each JSP database is related to a particular table. The problem occurs when loading special JSP, which is in large numbers in the table. Entering the app also showed the problem of display and it takes a very long time to show the Home Page.

I need this app to work with the best performance. Due to performance issues, we do not want to lose our precious customers. I do not know where the barrier is, and what to do to tune the performance of my application. Some suggestions:

Some advice:

  • Make sure you have your connection manual Instead of opening the form, you are using a database connection pool.
  • Be sure to have the connection in the most narrow scope, that means never is not in the field as a field or higher.
  • Tune up your database: Apply indexes in tables based on your queries, divide our tables, tables on your own, etc.
  • Tune your questions: Write them to follow the indexes in your table, do not use it to check whether the query uses index criteria or linear search EXPLAIN Use your queries in subqueries, etc.
  • Use paging to display your table. Preferably, use small-sized pages of rows such as 10 or 15 per table (or any other defined value in your application) in one view. The maximum size will depend on your performance. This is not the same display thumbnail for the video as compared to just plain text, in addition, it also helps to know the amount of column and their content, it does not show the same 250 rows displayed in two columns, which many Instead of displaying a report with a column, there is a simple number.

In addition to these, use a Vimeo VM or Java Mission Control or a profiler like Yourkit, which removes the obstacles on your application.


Comments

Post a Comment

Popular posts from this blog

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
Read more

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
Read more

c# - MySQL Parameterized Select Query joining tables issue -

-
I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
Read more