jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sidhama <sidhartha.mal...@wipro.com>
Subject Fine tunning jcr query
Date Mon, 12 Oct 2009 15:44:01 GMT

Sir/Mam, 
I am executing the following query for getting the counts of Servers.
-----------
/jcr:root/Catalogs/catalog_1/Servers//*[jcr:like(@serverID, '%')]
-----------

It has around 150,000 nodes and it takes closely 26 secs for retrieving the
results, 
I modified it to by removing <Servers> folder
-----------
/jcr:root/Catalogs/catalog_1//*[jcr:like(@serverID, '%')]
-----------

It is giving a response time of 19secs, can i reduce it further well below
6/7 secs?

Please suggest if i could fine tune the query, why any jcr query executed
first time takes a longer time, but subsquently takes less time?

Thanks
Sidharth

-- 
View this message in context: http://www.nabble.com/Fine-tunning-jcr-query-tp25858002p25858002.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.


Mime
View raw message