This week's giveaway is in the OCPJP forum.
We're giving away four copies of Practice Tests for OCP Java 17 Certification Exam (1Z0-829) and have Paul Anilprem on-line!
See this thread for details.
Win a copy of Practice Tests for OCP Java 17 Certification Exam (1Z0-829) this week in the OCPJP forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
Bartenders:
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

A design and performance question

 
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
author & internet detective
Posts: 41110
848
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
author
Posts: 11962
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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).
 
It runs on an internal combustion engine. This ad does not:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic