Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JMS Queue X SQL INSERT statement Performance

 
Bernardo Hermont
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What does "will last more" mean? Will it perform longer? Will it take longer to complete? Something different?
 
Andrew Monkhouse
author and jackaroo
Marshal Commander
Pie
Posts: 11851
185
C++ Firefox Browser IntelliJ IDE Java Mac Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Bernardo Hermont
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 20711
29
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic