Discussions

Performance and scalability: DAO performance experiment

Bookmark and Share Get thread feed

  1. DAO performance experiment (3 messages)

    • Posted by: null
    • Posted on: December 11 2003 09:22 EST
    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?
    Reply to this

    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.
    Reply to this Reply to original

  3. What about using Stored Procedures & DBLinks[ Go to top ]

    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.
    Reply to this Reply to original

  4. DAO performance experiment[ Go to top ]

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