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.
