| Author |
Message
|
| achocks |
 Posted: Mon Dec 17, 2012 7:24 am Post subject: Performance - JAR Files Vs Cached Oralce Database |
 |
|
Voyager
Joined: 28 Nov 2011
Posts: 82
|
I have a big dilemma whether to use a huge JAR file or Cached Oracle Database tables to load 400 meta data values.
In a transformation flow, there is a need to look-up 400 Translation tables.
What is the best way to design this.
A) Is it better to load it to a Oracle and use Cached tables in Flow
B) Create a huge JAR files and use Java compute node.
Which will be best in terms or performance and ease.
Any advice will be very helpful.
Thanks in advance! |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Mon Dec 17, 2012 7:29 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
What have you tried, what have you measured, what went wrong? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| achocks |
| Posted: Mon Dec 17, 2012 7:34 am Post subject: |
|
|
Voyager
Joined: 28 Nov 2011
Posts: 82
|
I am in the designing phase .
Please let me know if you have any experience with similar situations. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Dec 17, 2012 7:36 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
How often do these properties change?
How often do they need to be loaded?
How many things need to know about them - and how frequently do those things need to change?
Why have you limited the only choices you will possibly take to exactly the two options you have mentioned? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Dec 17, 2012 7:46 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
For most applications, database-driven is the way to go since you can change the behavior of your application without modification and redeployment of code.
A Jar is a good first step as it allows you to prototype a solution then code a database-driven solution later once the design settles down.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Dec 17, 2012 7:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
For most applications, database-driven is the way to go since you can change the behavior of your application without modification and redeployment of code.
A Jar is a good first step as it allows you to prototype a solution then code a database-driven solution later once the design settles down. |
Yeah, but user defined properties are at least as good a first step. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Dec 17, 2012 7:53 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
I agree. I like a Jar better as all the code is in one place. The exception would be if the administrator would create a script containing all the relevant properties for UDPs. 400 UDPs are alot to manage manually.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| achocks |
| Posted: Mon Dec 17, 2012 8:23 am Post subject: |
|
|
Voyager
Joined: 28 Nov 2011
Posts: 82
|
Thanks everyone!
These meta data changes when ever a new field is added . So ot changes pretty much every month and it needs to be loaded every month.
If there are better ways than the two I mentioned..Please let me know.
Surely I will consider..
Thanks again! |
|
| Back to top |
|
|
| kash3338 |
| Posted: Mon Dec 17, 2012 8:35 am Post subject: Re: Performance - JAR Files Vs Cached Oralce Database |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| achocks wrote: |
Which will be best in terms or performance and ease.
|
In case of both performance and ease of maintenance, I guess use of Oracle table and loading into Cache is always better in your case since, the data keeps updating every month.
You just need to reload the EG or refresh the Cache when the data is updated in the Oracle DB.
In case of UDP or JAR it is not so easy a process to refresh the data as in the case of DB/Cache usage. |
|
| Back to top |
|
|
| visasimbu |
| Posted: Mon Dec 17, 2012 9:01 am Post subject: |
|
|
Disciple
Joined: 06 Nov 2009
Posts: 171
|
| achocks wrote: |
If there are better ways than the two I mentioned..Please let me know.
|
How about placing a 400 records as a XML message in temp queue and browsing a same in the message flow using MQGET node ?
Last edited by visasimbu on Mon Dec 17, 2012 9:24 am; edited 1 time in total |
|
| Back to top |
|
|
| achocks |
| Posted: Mon Dec 17, 2012 9:09 am Post subject: |
|
|
Voyager
Joined: 28 Nov 2011
Posts: 82
|
| May be I was not clear..It is not 400 records..It is 400 tables with each table has anywhere from 10 to 100 records. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Dec 17, 2012 9:14 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Then you shouldn't use anything other than a database, and you should strongly consider making sure you are at v8.0.0.1 so you can use global cache. |
|
| Back to top |
|
|
| achocks |
| Posted: Mon Dec 17, 2012 9:16 am Post subject: |
|
|
Voyager
Joined: 28 Nov 2011
Posts: 82
|
|
| Back to top |
|
|
|
|
