Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: domain of patricioe@gmail.com
 designates 209.85.160.42 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=B+q5MFnSHTdNYlzEWfhbpiIRzXtVzAPiiNBfJbX0tQY3TNLrlX4uVwaKTxkZJJQbUl
         WytSI1oC3Yk7R8cLQVb45Z/sSSgzQTtbI1c+u4zHoou5BERlUPk3j8QvJid2FJk/BKYE
         0SERlhSLh2NM3cOrdgB/JUKCJXpGb9TjXn/+s=
MIME-Version: 1.0
Date: Tue, 9 Mar 2010 16:41:23 -0800
Message-ID: <4ab7f8471003091641n5f983c1au5aee861048e11010@mail.gmail.com>
Subject: Help to improve this SQL2 query
From: =?ISO-8859-1?Q?Patricio_Echag=FCe?= <patricioe@gmail.com>
To: users@jackrabbit.apache.org
Content-Type: multipart/alternative; boundary=001636b2ac50c596f10481678e3c

--001636b2ac50c596f10481678e3c
Content-Type: text/plain; charset=ISO-8859-1

Hi all, I'm running this query in my repository with 5k users (nodes) where
everyone has one Application node and each application has 4 Folder nodes.

root
   |
(I have here some system folder to keep only 2k users )
   |
user 1      .......... user 5000
    \
  application
        \
   ---------------
   \     \     \     \
  F1  F2  F3   F4

For some reason the query (1) executes really fast vs the second one that
executes 20 times slower. I'm worried because the repository is almost empty
and this query shold be running as fast as (1).

(1) executed in 0.06 s. (SELECT * FROM [scrat:app] AS nodeType WHERE
nodeType.vparentid = 'd93c442a-2096-444a-9b6c-e52ffd4d88b5' AND
nodeType.[jcr:name] = 'Email')

(2) executed in 1.14 s. (SELECT * FROM [myapp:folder] AS nodeType WHERE
nodeType.vparentid =  'da392a3b-949c-4542-a75b-283664547878' AND
nodeType.[jcr:name] = 'Inbox')

My caches are by default. BundleCache in PM is 128 MB (seems ok).
I'm running against Cassandra which is extremely fast.

Am I doing something wrong? May someone suggest any way to speed it up?

thanks in advance

-- 
Patricio.-

--001636b2ac50c596f10481678e3c--