Solved

JMS or not ?

Posted on 2004-04-30
3
405 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
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
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.

828 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