Uploaded image for project: 'Doctrine 2 - ORM'
  1. Doctrine 2 - ORM
  2. DDC-217

Result cache should cache the SQL result and not the final objects

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0-ALPHA3
    • Fix Version/s: 2.2
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None

      Description

      When fetching objects and using a result cache, it would probably be better to cache the SQL result array instead of the hydrated objects. That way, when grabbing from the cache managed entities can be returned. Also, caching is more efficient since an SQL result array does not need to be serialized/unserialized when storing in apc or memcached.

        Issue Links

          Activity

          romanb Roman S. Borschel created issue -
          romanb Roman S. Borschel made changes -
          Field Original Value New Value
          Priority Major [ 3 ] Minor [ 4 ]
          romanb Roman S. Borschel made changes -
          Link This issue is referenced by DDC-446 [ DDC-446 ]
          romanb Roman S. Borschel made changes -
          Fix Version/s 2.1 [ 10022 ]
          beberlei Benjamin Eberlei made changes -
          Assignee Roman S. Borschel [ romanb ] Guilherme Blanco [ guilhermeblanco ]
          beberlei Benjamin Eberlei made changes -
          Fix Version/s 2.x [ 10090 ]
          Fix Version/s 2.1 [ 10022 ]
          beberlei Benjamin Eberlei made changes -
          Link This issue is duplicated by DDC-1279 [ DDC-1279 ]
          beberlei Benjamin Eberlei made changes -
          Assignee Guilherme Blanco [ guilhermeblanco ] Benjamin Eberlei [ beberlei ]
          beberlei Benjamin Eberlei made changes -
          Fix Version/s 2.2-DEV [ 10157 ]
          Fix Version/s 2.x [ 10090 ]
          beberlei Benjamin Eberlei made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira [ 10634 ] jira-feedback [ 14207 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira-feedback [ 14207 ] jira-feedback2 [ 16071 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira-feedback2 [ 16071 ] jira-feedback3 [ 18324 ]

            People

            • Assignee:
              beberlei Benjamin Eberlei
              Reporter:
              romanb Roman S. Borschel
            • Votes:
              5 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: