Smart Content not working on PHPCR with mysql

[tomsvogel]

jackalope/jackalope-doctrine-dbal#217

[dantleech]

Thidls is a non-trivial fix for jackalope but not too hard. If anybody at.MA wants to take it on.. if not we.only encountrr this issue in one place and the workaround is to select from nt:unstructured wher jcr:mixinTypes="sulu:content"

Thomas Schedler [email protected] wrote:

jackalope/jackalope-doctrine-dbal#217

---

Reply to this email directly or view it on GitHub:
#204 (comment)

Sent from my Android device with K-9 Mail. Please excuse my brevity.

[dantleech]

Benchmarks for selecting [jcr:mixinTypes] as critieria vs. as source.

The jackrabbit server was restarted between each test.

If the two different queries are run seqeuntially, then the second is always cached, suggesting that jackrabbit does a criteria select internally.

select * from [nt:unstructured] where [jcr:mixinTypes] = 'sulu:content';
0.72
0.66
0.71
0.67

select * from [sulu:content];
0.67
0.67
0.70
0.67

[dantleech]

PR: https://github.com/sulu-cmf/SuluContentBundle/pull/237/files

[tomsvogel]

+1