?
Solved

JMS or not ?

Posted on 2004-04-30
3
Medium Priority
?
434 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
  • 2
2 Comments
 
LVL 4

Accepted Solution

by:
illusionz70 earned 200 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses
Course of the Month16 days, 2 hours left to enroll

850 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