Solved

improving performance of SAS application

Posted on 2014-01-21
3
285 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
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
dlethe earned 500 total points
Comment Utility
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
Comment Utility
i found that JPA caching does the trick, the speed improved dramatically.
0
 
LVL 47

Expert Comment

by:dlethe
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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 …

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now