This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes A design and performance question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "A design and performance question" Watch "A design and performance question" New topic
Author

A design and performance question

raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30076
    
149

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.


[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
raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
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

Joined: Sep 05, 2001
Posts: 139
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.


SCJP2
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
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).


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: A design and performance question
 
Similar Threads
concurrent access to derby database
Connecting to the Java "derby" Netbeans database without Netbeans.
Derby Embedded vs. Derby Network Server
Related to Design
derby dialect