File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Architect Certification (SCEA/OCMJEA) and the fly likes JMS Queue X SQL INSERT statement Performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Certification » Architect Certification (SCEA/OCMJEA)
Bookmark "JMS Queue X SQL INSERT statement Performance" Watch "JMS Queue X SQL INSERT statement Performance" New topic
Author

JMS Queue X SQL INSERT statement Performance

Bernardo Hermont
Greenhorn

Joined: May 20, 2008
Posts: 11
Hey fellows,

For the logging in a clustered system, I'm planning to store all log information in a database table.
I'm not sure if a SQL INSERT statement WILL LAST MORE than sending a message to a JMS Queue Server.

I'm close to say that a SQL INSERT statement will last more.

Any experiences/comments to share?

Cheers


scjp 1.4, scwcd 1.4, scbcd 5.0, scea 5.0, OMG OCUP Fundamental
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29233
    
135

What does "will last more" mean? Will it perform longer? Will it take longer to complete? Something different?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11278
    
  59

If you are writing code for the assignment provided to you by Sun/Oracle then you are probably diving in too deep. You may want to rethink what you are intending to deliver.


The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
Bernardo Hermont
Greenhorn

Joined: May 20, 2008
Posts: 11
Hi everyone!

Thanks for the replies.

Will last more means that it will take longer to complete.
I just thinking about the logging strategy, I'm not writing any code.

Regards

Bernardo
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18121
    
    8

So, you're asking us to estimate the time required to insert a row into a database which has an unknown number of rows already there, and an unknown number of indexes, and an unknown set of insert triggers, over an unknown network. And you're asking us to estimate the time required to send a JMS message of an unknown size over an unknown network. And then you're asking us to tell you which number is bigger. I'm sure that when your question is put this way, you can see that you aren't going to get any useful answers.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JMS Queue X SQL INSERT statement Performance
 
Similar Threads
Help Re: getLastInsertId()
JMS questions
identity
Log 4j JDBC appender
processing huge file in multithreaded env