Doctrine 2 - ORM

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

Details

  • Type: Improvement Improvement
  • Status: Resolved Resolved
  • Priority: Minor 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

is duplicated by

Improvement - An improvement or enhancement to an existing feature or task. DDC-1279 Shouldn't Cached Results Trigger LifeCycleEvents?

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.
is referenced by

Improvement - An improvement or enhancement to an existing feature or task. DDC-446 Cached resultset do not add Entities in UnitOfWork

  • Major - Major loss of function.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.

Activity

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

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Roman S. Borschel
Vote (5)
Watch (6)

Dates

  • Created:
    Updated:
    Resolved: