Discussions

Performance and scalability: DAO performance experiment

  1. DAO performance experiment (3 messages)

    I compared DAO methods:

    JDO - fastest
    JDBC - a bit slower
    CMP/EJB - slowest by far

    I used a tool called CodeFutures Firestorm.

    Is this consistent with anyone elses experience?

    Threaded Messages (3)

  2. DAO performance experiment[ Go to top ]

    I usually find JDBC fastest, if you tweak the SQL. But it is the hardest to maintain.

    The skinny on CMP/EJB is that its throughput is slower, but it is supposed to scale better.

    Also, try adding Hiberate to your list of things to check.
  3. Do all of you consider using stored procedures to offload the data processing overhead to the database or using dbLinks to collect information from different databases instead of using various datasources ?

    Can any one tell the the pros and cons of using dblinks for accessing data from different databases over using different datasources ?

    Of cource, I am talking about using JDBC in both the cases.
  4. DAO performance experiment[ Go to top ]

    The JDO uses the JDBC so.. the test results are interesting to say the least.