Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

A design and performance question

 
raminaa niilian
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Thank you for reading my post
I should design and implement an application which is going to run on tomcat 5.5 and Database can be one of derby ,sqlServer , Mysql.
Problem is that this application should be able to have about 15 -20Transaction in 1 second .They have no extra power servers , just an ordinary hosting plan.
my question is : which of this database is better to choose ?
i thought that derby could be better because it can be embeded into my application .
can derby carry out 15-20 transacion in 1 secod ?
is it feasible with using DAO pattern and plain JDBC ,or it need some other requirement ?
[ October 30, 2005: Message edited by: Bear Bibeault ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Raminaa,
It depends on what is being done in the transaction, how much contention there is, the load on the server and the partitioning between different clients on the hosting plan.

It's certainly possible to write an app that performs 20 transactions per second. if you use generic SQL, you can change databases later on.

For now, I recommend trying out the different databases on the hosted server and doing a comparison. Derby may or may not be better. If you are constrained on memory, Derby will page to disk more.
 
raminaa niilian
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Thank you for reply.
There are not sophisticated operation per transaction 3 insert + 3 update .
it is a web application at most 20 connection at the same time.
Generally it is going to be an ADs manager , provider system
A system that manage and handle hist for diffrent Ads (banners).

can a dedicate p4 3000 + 512M RAM handle this ?

Thank you again.
 
Mahesh Rana
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Raminaa,

Here is one more variable you can add to your comparison chart:

If you could, try putting all your SQLs in a db procedure.

Positive side of it is there will be minimum network latency.
Draw back is, it may not be generic over different RDBMS.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Deep Narsay:
If you could, try putting all your SQLs in a db procedure.

Positive side of it is there will be minimum network latency.
Draw back is, it may not be generic over different RDBMS.

Correction: it won't be generic over different RDBMS. Not between the products you mentioned (of which some don't even support any kind of stored procedures).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic