Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Should I use a Servlet for this ?

 
Paul Dabely
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, our web application contains a lot dynamic pages that are built accessing a backend DB. Right now we are using a very old scripting technology to build the pages (Powerdynamo from Sybase). This scripting language was out before JSP and although it works pretty good, it fails miserably when asked to do any serious looping through result sets. This becomes quite evident when the user runs some of the large reports that require a lot of rows from the database to produce the output. This tends to drag down our webserver because all processing of the scripts is done on the webserver. My question is - would a servlet be more appropriate for these type reports? If so - I am correct in assuming that all I need to do is change the FORM tag in my html to post to a servlet and then get a servlet set up in an application server on another machine? How does the servlet write out the html back to the users browser? Can it be done just using out.println from the servlet ? Thanks - Paul
 
Mark Spritzler
ranger
Sheriff
Posts: 17290
9
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well actually it more seems that you have more than one question, or should I say more than one solution.

First I would say that using Struts to rebuild your application would make things a lot better for you. Which, in essence, means yes to your question about using servlets.

Now as far as reports go with lots of data, I actually strongly recommend using a Report Server to pre-generate the report, if you can.

No if you can't pre-generate then I suggest looking into Crystal Reports Java solution, you can create your report in Crystal, then use their jar file to generate the report at the client side. I think in this case Crystal will access you database directly and therefore have better speed than having to go through your web server.

Now that is my suggestion and description from a high level, there are more specifics that you will need to look at.

Mark
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!