Solved

improving performance of SAS application

Posted on 2014-01-21
3
317 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:
David 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:David
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

Tutorials alone can't teach real engineering

So we built better training tools.

-Hands-on Labs
-Instructor Mentoring
-Scenario-Based Tests
-Dedicated Cloud Servers

All at your fingertips. What are you waiting for?

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

691 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