Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

JMS or not ?

Posted on 2004-04-30
3
Medium Priority
?
431 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 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

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…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This video teaches viewers about errors in exception handling.
Suggested Courses

618 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