jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kazim_ssuet@yahoo.com" <kazim_ss...@yahoo.com>
Subject Re: query.execute() and result.getNodes() taking over 20 min each
Date Wed, 27 Oct 2010 23:18:07 GMT

Got it.

I modified query creation from
queryManager.createQuery(queryString, Query.JCR_SQL2)
to
queryManager.createQuery(queryString, Query.SQL)

and modified query from
SELECT * FROM [csi:file] WHERE [csi:oid] = 'WFC.e1.5032907' AND
ISDESCENDANTNODE('/WFC/e1/01-05-2010/5032907') 
to
SELECT * FROM csi:file WHERE csi:oid = 'WFC.e1.5032907'


and now search only takes 30-40 mili sec on avg.

Thanks,
KS.
-- 
View this message in context: http://jackrabbit.510166.n4.nabble.com/query-execute-and-result-getNodes-taking-over-20-min-each-tp3015942p3016422.html
Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.

Mime
View raw message