query result caching

[dbu]

caching query results could improve the performance significantly.

once done, also update DoctrinePHPCRBundle to integrate the cache with symfony.

[levuro]

hi david, are there any news on this feature? is this on some kind of roadmap? How complicated is this to implement? is this something you can copy from the other doctrine project or does it need to be developed from scratch?

[dbu]

I just added the cross reference. @lsmith77 hopefully knows more

[koemeet]

Hi, I wanted to know if there is any progress on this issue?

[dbu]

i am not aware of anybody working on this currently.

it would likely mean porting a similar functionality from doctrine orm to phpcr-odm. or better seeing if the functionality can be shared with a common library for the functionality.

[SalvatorePollaci]

Hi, are there any updates on this? How can phpcr be used in production if everytime a page is requested, a query to jackrabbit is made?

[dbu]

the comment from last summer still applies. i am happy to review the pull request if somebody works on this.

single node lookups (with prefetch for children) take about 5 - 10 milliseconds, so if you design your site properly, it should work ok in production. if you run queries for everything, you should look at instead loading documents by path instead of querying for them. http reverse proxy caching also helps. but as said, it would be great to have the cache as well, if somebody wants to work on it. first step would be to check how much reusable this already is in doctrine commons / orm.