Forum:

Servlets

Speed up Application Created USing Servlets and JSP

carina caoor

Ranch Hand

Posts: 300

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi i created an application using Servlets and jsp which access data from data base by running queries ... as the queries running are extracting data from multiple tables my application dont show much speed while running... now i have got another project to design in which i need to run, time consuming procedures which might take 5 - 10 minutes of time can anybody suggest me how do i increase the speed from servlets and jsp or look more interactive while queries run, also can anybody give me some good sample projects designed i want to have a look at the User Interface designed. In my previous project i designed the front end screen what user see and interact in jsp with javascripting for validations and the business logic is handled by servlets .. Is this approach of designing screens using jsp correct .

sample jsp

<html>
<head><title>Reports</title>
<LINK REL="STYLESHEET" type="TEXT/CSS" HREF="../src/jsp/FAFileCSS.css">
<script type="text/javascript" language="JAVASCRIPT" src="../src/jsp/ReportsScript.js"></script>
<script type="text/javascript" language="JAVASCRIPT" src="../src/jsp/jquery-1.2.6.js"></script> 
  <jsp:include page="../AI/Cssincludes"/>

</head>
 <%
     response.setHeader("Cache-Control","no-store"); //HTTP 1.1
     response.setHeader("Pragma","no-cache"); //HTTP 1.0
     response.setDateHeader ("Expires", 0); //prevents caching at
 %>
<body onload='setFileFocus();'>

<LABEL ID="label1">
Upload plot nos (.xls format).</LABEL>
  <INPUT TYPE="file" NAME="xls_filename" ID="rfileselect" onchange="getFileName();">
 <LABEL ID="label3"> 
Select environment:</LABEL>

<INPUT TYPE="RADIO" NAME="environment" ID="rtenviradio1" value="UAT"><LABEL ID="rtlabel4">UAT</LABEL>
<INPUT TYPE="RADIO" NAME="environment" ID="rtenviradio2" value="DEV"><LABEL ID="rtlabel41">DEV</LABEL>
<INPUT TYPE="RADIO" NAME="environment" ID="rtenviradio3" value="PROD"><LABEL ID="rtlabel42">PROD</LABEL>
  <LABEL ID="rpropertylabel1"> 
Property Type:</LABEL>
<select ID="rproperty11" name="propertytype">
 <option></option>
<option value="BASE">BASE</option>
<option value="GROWTH">GROWTH</option>
<option value="ALL" selected="1">ALL</option>
</select>

</FORM>

<FORM NAME="FAForm2">

<FONT SIZE="2" COLOR="black" >

<DIV ID="gridbox1"></DIV>			
</DIV>
<DIV ID='rpttotalrowdiv' READONLY> </DIV><DIV ID='rpttotalrowdiv2' READONLY> </DIV>
<button ID='rptselectall'    onclick='getReportsDetails();' title="Get Reports Details">GO</button>
<button ID='rptcanceluploadbutton' onclick='cancelUpload();' title="Cancel Upload">Reset</button>
<button ID='rexcelbutton' onclick='excelExport();'     title="ExportToExcel">ExportToExcel</button>
<iframe ID='if1'></iframe>
<DIV ID='finalplotdiv1' READONLY>
    <DIV ID="gridbox2"></DIV>

</script>

</DIV>

</FONT>
</FORM>
<DIV>
</body>
</html>

Bauke Scholtz

Ranch Hand

Posts: 2458

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Regarding to the database side (datamodel/SQL): make sure that your datamodel is designed the right way and that your SQL returns ONLY the rows that you actually need and if necessary also in the order that you want.

Regarding to the server side (Java/JSP): make sure that you write efficient code and don´t do memory hogging stuff. Running a profiler may help a lot to find inefficient code and memory leaks.

Regarding to the client side (HTML/JS): make sure that your HTML is not unnecessarily big and that your JS is also written efficient. There are also profilers for JS.

carina caoor

Ranch Hand

Posts: 300

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Just wanted to ask is that a good practise writing html code inside the jsp? also can anybody name me the profilers for js and jsp that identifies the unnecessary things.

Paul Sturrock

Bartender

Posts: 10336

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

ruquia tabassum wrote:Just wanted to ask is that a good practise writing html code inside the jsp?

Yes. Unless you page is completely static in which case a plain old HTML page will do.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

Bauke Scholtz

Ranch Hand

Posts: 2458

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

ruquia tabassum wrote:Just wanted to ask is that a good practise writing html code inside the jsp?

It belongs in there. JSP is a view technology.

also can anybody name me the profilers for js and jsp that identifies the unnecessary things.

Google can do it.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.