You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Lyudmil Latinov (JIRA)" <ju...@ws.apache.org> on 2010/11/14 16:09:16 UTC

[jira] Commented: (JUDDI-431) find_tModel performance - 20s for exact name + 3 KeyedReferences

    [ https://issues.apache.org/jira/browse/JUDDI-431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12931831#action_12931831 ] 

Lyudmil Latinov commented on JUDDI-431:
---------------------------------------

Performace quick win is in org.apache.juddi.api.impl.InquiryHelper.java - public static List<?> findTModel:
keysFound = FindTModelByNameQuery.select(em, findQualifiers, body.getName(), keysFound); to be moved on first place.
So first find based on Name criteria is performed and on those results find on CategoryBag criteria is performed.
For my usecase execution time was significantly reduced.

> find_tModel performance - 20s for exact name + 3 KeyedReferences
> ----------------------------------------------------------------
>
>                 Key: JUDDI-431
>                 URL: https://issues.apache.org/jira/browse/JUDDI-431
>             Project: jUDDI
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 3.0.3
>            Reporter: Lyudmil Latinov
>            Assignee: Kurt T Stam
>            Priority: Minor
>
> I have jUDDI with DerbyDB with 440 tModels inside.
> When searching tModel for "exactMatch" name + CategoryBag with 2 KeyedReferences execution time is about 2s.
> When searching tModel for "exactMatch" name + CategoryBag with 3 KeyedReferences execution time is about 20s.
> With increasing number of KeyedReferences time for queue increases.
> Some performance improvements will be nice enhancement.
> Request for name + 2 KeyedReferences
> <?xml version="1.0" encoding="UTF-8" ?>
> <Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
>   <Body>
>     <find_tModel  xmlns="urn:uddi-org:api_v3">
>             <findQualifiers>
>                 <findQualifier>exactMatch</findQualifier>
>                 <findQualifier>andAllKeys</findQualifier>
>             </findQualifiers>
>             <name>test classification tmodel1</name>
>             <categoryBag>
>                 <keyedReference tModelKey = "uddi:uddi.org:categorization:types" keyName = "uddi-org:types:unchecked" keyValue = "unchecked"/>
>                 <keyedReference tModelKey = "uddi:uddi.org:categorization:types" keyName = "uddi-org:types:categorization" keyValue = "categorization"/>
>             </categoryBag>
>         </find_tModel>
>     </Body>
> </Envelope>

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.