Re: AW: jcr-sql2 queries "with or without" where-clause :-(

2010-11-18 Thread Serge Huber
Hello Clemens, Yes that is similar to what I am seeing here. I have commented on the ticket https://issues.apache.org/jira/browse/JCR-2715 that we don't seem to be going through Jukka's new optimized code for simple queries that don't use joins, which is a shame. What happens if you use SQL-

AW: jcr-sql2 queries "with or without" where-clause :-(

2010-11-18 Thread Clemens Wyss
addendum: >select * from [task] where @employeeinchargeid = 3 returns after 90s to 120s -Ursprüngliche Nachricht- Von: Clemens Wyss [mailto:clemens...@mysign.ch] Gesendet: Donnerstag, 18. November 2010 17:56 An: dev@jackrabbit.apache.org Betreff: jcr-sql2 queries "with or without" where-c

jcr-sql2 queries "with or without" where-clause :-(

2010-11-18 Thread Clemens Wyss
I know that jcr-sql2 is "in progress". Still I would like to know if my oberservations are at all possible: I have approx. 76'000 [task]-nodes in my repo. >select * from [task] takes approx. 870ms, :-) >select * from [task] order by [jcr:score] takes btw. 2s and 5s (still somehow "acceptable")

[jira] Commented: (JCR-2715) Improved join query performance

2010-11-18 Thread Serge Huber (JIRA)
[ https://issues.apache.org/jira/browse/JCR-2715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12933438#action_12933438 ] Serge Huber commented on JCR-2715: -- Hello Jukka, I was going over some performance tests, a

[jira] Resolved: (JCR-2814) Login performance drop when using DefaultAccessManager

2010-11-18 Thread JIRA
[ https://issues.apache.org/jira/browse/JCR-2814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Dürig resolved JCR-2814. Resolution: Fixed Fix Version/s: 2.2.0 Fixed at revision 1036450 > Login performance drop whe

[jira] Commented: (JCR-2814) Login performance drop when using DefaultAccessManager

2010-11-18 Thread JIRA
[ https://issues.apache.org/jira/browse/JCR-2814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12933433#action_12933433 ] Michael Dürig commented on JCR-2814: I suggest to use a LRU map which starts out with a s

[jira] Created: (JCR-2814) Login performance drop when using DefaultAccessManager

2010-11-18 Thread JIRA
Login performance drop when using DefaultAccessManager -- Key: JCR-2814 URL: https://issues.apache.org/jira/browse/JCR-2814 Project: Jackrabbit Content Repository Issue Type: Improvement

[jira] Assigned: (JCR-2814) Login performance drop when using DefaultAccessManager

2010-11-18 Thread JIRA
[ https://issues.apache.org/jira/browse/JCR-2814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Dürig reassigned JCR-2814: -- Assignee: Michael Dürig > Login performance drop when using DefaultAccessManager > --

[jira] Commented: (JCR-2793) Typo in NodeTypeRegistry

2010-11-18 Thread Jukka Zitting (JIRA)
[ https://issues.apache.org/jira/browse/JCR-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12933388#action_12933388 ] Jukka Zitting commented on JCR-2793: Feel free to go ahead and commit this. > Typo in No

[jira] Updated: (JCR-2676) FileDataStore should check for lastModified error result

2010-11-18 Thread Thomas Mueller (JIRA)
[ https://issues.apache.org/jira/browse/JCR-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Mueller updated JCR-2676: Fix Version/s: 2.2.0 > FileDataStore should check for lastModified error result > ---