Solved

improving performance of SAS application

Posted on 2014-01-21
3
308 Views
Last Modified: 2016-02-10
i am working on an app that has the following:
frontend: html, js, and angular
middle tier: java restful service that simply converts data into JSON
backend: SAS service that the restful service methods call
oracle DB

i am trying to improve performance.  i tried moving most of the processing/business logics from the frontend to the java restful service layer, but didn't see any major improvement. another area of concern is that the DB is not located in the same location as the SAS service, which in turn is not co-located with the restful service layer.  so i see a lot of network latency and firewall issues that could be addressed.  also, i am wondering if it wouldn't be better to replace the SAS service with a JPA framework, with entity classes and DAO classes underneath the restful service.  what about using JDBC template to make direct calls to the DB, will scalability be an issue? thanks.
0
Comment
Question by:mmingfeilam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
dlethe earned 500 total points
ID: 39798720
Well, Java is an absolute pig in every aspect. If you are doing REST / JSON, then any way you can get away with a simple browser as the front end and a javascript library?

We're talking 1/100th of the same footprint.  Besides JAVA is just so insecure and you're finding more governments, businesses, and even end users saying no way will they let a JAVA app in the door.

You don't need JAVA to get to an oracle or any other database. Strip down the layers.  Look at jquery and some of the other libraries, and an embedded browser, php, perl, node.js or some other lightweight gateway.
0
 

Author Comment

by:mmingfeilam
ID: 39831476
i found that JPA caching does the trick, the speed improved dramatically.
0
 
LVL 47

Expert Comment

by:dlethe
ID: 39831519
Great.  For what it is worth, my son is in college now and the university is just finally flat out saying that JAVA is dead, and don't even think of turning in any project that uses JAVA unless it is a program to help migrate away from it.
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question