Marcel,
I am using jackrabbit 1.5.4 version and my dafault/workspace.xml config is
as follows
------
<?xml version="1.0" encoding="UTF-8"?>
<Workspace name="default">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager
interface
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
<!--<PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
-->
<!-- -->
</PersistenceManager>
<!-- Search index and the file system it uses.
class: FQN of class implementing the QueryHandler interface
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
</SearchIndex>
</Workspace>
-------
Please do let me know if i could modify something for improving performance.
Thanks for your reply.
Sid
Marcel Reutegger wrote:
>
> Hi,
>
> what version of jackrabbit are you using and what's your workspace.xml
> configuration?
>
> see also this post:
> http://www.nabble.com/Explanation-and-solutions-of-some-Jackrabbit-queries-regarding-performance-td15028655.html
>
> regards
> marcel
>
> On Fri, Oct 16, 2009 at 13:52, sidhama <[email protected]> wrote:
>>
>> Marcel,
>> Thanks for the response, i tried your suggestion, and it came down to 21
>> secs, but my requirement is something well below 10 secs.
>>
>> Is there any way i can utilize the lucene package provided with
>> jackrabbit
>> implementation with explicit programming.
>> If what are the config changes or overriding i need to do.
>> I searched through web but no pointer for creating customizing classes
>> from
>> lucene packages i.e. writing my own lucene query builder, queryImpl or
>> results etc.
>>
>> I need your suggestion.
>>
>> Thanks
>> Sidharth
>>
>>
>> Marcel Reutegger-5 wrote:
>>>
>>> Hi,
>>>
>>> like queries with a prefix wildcard are usually expensive. for your
>>> case you rather want to test the existence of the property:
>>>
>>> /jcr:root/Catalogs/catalog_1/Servers//*...@serverid]
>>>
>>> that's probably a lot faster.
>>>
>>> regards
>>> marcel
>>>
>>> On Mon, Oct 12, 2009 at 17:44, sidhama <[email protected]>
>>> wrote:
>>>>
>>>> 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.
>>>>
>>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Fine-tunning-jcr-query-tp25858002p25924125.html
>> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Fine-tunning-jcr-query-tp25858002p25973091.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
