Hi, I have perfomance problems querying items in the data module. I have around 1000 articles stored in the data module and want to query them on the following conditions:
1. Multiple itemtypes (ex: itemtype='news' AND itemtype='article') 2. Date interval (ex: between 2012-01-01 - 2012 - 03 - 30) 3. Order descending (i.e. latest article first) 4. Only return x number of items (ex: latest 10 articles) The queries I've come up with so far are far too slow (takes around 10 s). I guess the problem could be solved by optimizing the query, but I've also read JCR-SQL2 has reported performance issues http://blog.liip.ch/archive/2012/06/26/jackrabbit-and-its-two-sql-languages-some-findings.html My questions are; what would an optimal query look like given the above conditions (perhaps using setOffset and setLimit?) and are there performance issues with JCR-2? -- Context is everything: http://forum.magnolia-cms.com/forum/thread.html?threadId=c3a0ff14-696c-4c4f-a33b-38bb1a783946 ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
