Solved

improving performance of SAS application

Posted on 2014-01-21
3
297 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
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle sql query 7 58
eclipse with Angularjs2.0 3 34
by zero exception 10 39
Oracle Query - Convert letters to numbers and display the difference 3 18
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

813 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

12 Experts available now in Live!

Get 1:1 Help Now