1. OpenJPA
  2. OPENJPA-2068

Improve performance of java.util.Calendar fields


    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.0
    • Component/s: jdbc
    • Labels:


      While doing some performance testing, I've found that we could improve the performance of loading Entities that have java.util.Calendar fields. When loading the data into a Calendar field, we actually create two Calendar instances per field. Normally creating an extra instance wouldn't be that big of a deal, but since creating a Calendar is very expensive I would like to remove creation of the extra instance.

      The call flow is something like this:

      • em.find(...) // find an Entity which has a calendar field
        ... execute query, processing result set...
      • DBDictionary.getCalendar(ResultSet,...) // Here we pull a Timestamp out of the result set, and create an unproxied Calendar instance.
        // now while trying to store the Calendar into the Entity instance, we find that this type needs to be proxied.
        SingleFieldManager.proxy(...) // Here we create the second Calendar instance, which is a proxied calendar

      I'd like to add a configuration property to DBDictionary that tells the runtime to always create proxied calendar instances. This would remove the creation of the initial un-proxied instance. For a large majority of application which use Calendars this would help.

      As always, there is a catch to this approach. If you were to execute a query such as : em.createQuery("SELECT c.myCal FROM CalendarEntity c where", MyCalendar.class), you would get back a proxied instance. This shouldn't be that big of a deal... but still a bit of a quirk.


        Albert Lee made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Rick Curtis made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Rick Curtis made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Rick Curtis made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.2.0 [ 12315910 ]
        Resolution Fixed [ 1 ]
        Rick Curtis made changes -
        Field Original Value New Value
        Attachment OPENJPA-2068.patch [ 12502019 ]
        Rick Curtis created issue -


          • Assignee:
            Rick Curtis
            Rick Curtis
          • Votes:
            0 Vote for this issue
            0 Start watching this issue


            • Created: