Solved

JMS or not ?

Posted on 2004-04-30
3
409 Views
Last Modified: 2010-03-31
Hi
I have application which works towards a db.
The application access a specific table in the db a lot (and I mean a lot something around 60 accesses in a second for update records, each access update one record).
We decide to change our design and access the db in a bunch operation, Instead of accessing the table for each update action, the application group X update requests and access the db in one action.

The application and db runs on different machines.

MY questions are:
1.  Should I group the bunch in the application side or in the db side?  I guess the answer will be in the application side to reduce network load.
2. Should I use JMS for this purpose or a simple 'home made' implementation queue?  The requirements from this queue is to bunch messages while the consumer of this queue should access the db when in has X messages or after Y seconds.
3. Is it possible follows the requirements I mentioned in question 2 when using JMS (specially gather X messages)?

  Thanks
0
Comment
Question by:dannysh
[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 4

Accepted Solution

by:
illusionz70 earned 50 total points
ID: 10974535
hi,
   i guess technology is there only to be used. and whenever messages are to be stored and passed on to consumer JMS is ideal.the only backdrop maybe that some effieciency issues may loom over JMS.also consider whether you will be able to use a receiver for the messages at your db side.bunch the messages on ur jms Queue and wake up your client to receive messages once in a while.
 a realistic advice would be to not to bunch the messages.put the messages on queue.just make sure your receiver recieves a bunch of messages from the queue and does the db operations. is ur db massively parallel???

if there is any part unclear post your queries

cheers,
0
 
LVL 4

Expert Comment

by:illusionz70
ID: 11040854
makes no sense....
no response from the poster...... wats the use of such points???


0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
hibernate insert example 13 40
jsp error 6 47
junit as external jar or library 7 40
Java array 10 65
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
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 …

730 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