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
Solved

improving performance of SAS application

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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.

791 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