[esb-issues] [JBoss JIRA] Commented: (JBESB-1675) Possible Juddi Performance problems
Kevin Conner (JIRA)
jira-events at lists.jboss.org
Wed Jul 30 06:56:45 EDT 2008
[ https://jira.jboss.org/jira/browse/JBESB-1675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12423008#action_12423008 ]
Kevin Conner commented on JBESB-1675:
-------------------------------------
I have been through the scout/jUDDI source code for the registerEPR operation.
The following are the associated lines where the main handling occurs. All are 1:1 mappings between our code and (eventually) jUDDI with the exception of the saveServiceBindings call within scout makes two invocations to jUUDI
ClassificationScheme cScheme = bqm.findClassificationSchemeByName(findQualifiers, "org.jboss.soa.esb.:category");
FindTModelFunction.execute(RegistryObject) line: 165
sql is: SELECT M.TMODEL_KEY,M.LAST_UPDATE,M.NAME,M.DELETED FROM TMODEL M WHERE M.DELETED IS NULL AND M.NAME = ? ORDER BY M.NAME DESC,M.LAST_UPDATE DESC
FindTModelFunction.execute(RegistryObject) line: 182
sql is: SELECT AUTHORIZED_NAME,OPERATOR,NAME,LANG_CODE,OVERVIEW_URL,DELETED FROM TMODEL WHERE TMODEL_KEY=? AND DELETED IS NULL
BulkResponse response = bqm.findServices(null, findQualifiers, namePatterns, classifications, null);
FindServiceFunction.execute(RegistryObject) line: 181
sql is: SELECT S.SERVICE_KEY,S.LAST_UPDATE FROM BUSINESS_SERVICE S,SERVICE_CATEGORY C WHERE C.SERVICE_KEY = S.SERVICE_KEY AND ((C.TMODEL_KEY_REF = ? AND C.KEY_VALUE = ?)) ORDER BY S.LAST_UPDATE DESC
FindServiceFunction.execute(RegistryObject) line: 181
sql is: SELECT S.SERVICE_KEY,S.LAST_UPDATE,N.NAME FROM BUSINESS_SERVICE S,SERVICE_NAME N WHERE N.SERVICE_KEY = S.SERVICE_KEY AND ((UPPER(NAME) = ?)) AND S.SERVICE_KEY IN (?,?,?,?,?,?,?,?) ORDER BY N.NAME DESC,S.LAST_UPDATE DESC
FindServiceFunction.execute(RegistryObject) line: 198
sql is: SELECT BUSINESS_KEY FROM BUSINESS_SERVICE WHERE SERVICE_KEY=?
FindServiceFunction.execute(RegistryObject) line: 198
sql is: SELECT LANG_CODE,NAME, SERVICE_NAME_ID FROM SERVICE_NAME WHERE SERVICE_KEY=? ORDER BY SERVICE_NAME_ID
ClassificationScheme cScheme = bqm.findClassificationSchemeByName(findQualifiers, "org.jboss.soa.esb.:category");
FindTModelFunction.execute(RegistryObject) line: 165
sql is: SELECT M.TMODEL_KEY,M.LAST_UPDATE,M.NAME,M.DELETED FROM TMODEL M WHERE M.DELETED IS NULL AND M.NAME LIKE ? ORDER BY M.NAME DESC,M.LAST_UPDATE DESC
FindTModelFunction.execute(RegistryObject) line: 182
sql is: SELECT AUTHORIZED_NAME,OPERATOR,NAME,LANG_CODE,OVERVIEW_URL,DELETED FROM TMODEL WHERE TMODEL_KEY=? AND DELETED IS NULL
br = blm.saveServiceBindings(serviceBindings);
BusinessLifeCycleManagerImpl.executeOperation(Object, String) line: 527
GetAuthTokenFunction.execute(RegistryObject) line: 79
sql is: SELECT PUBLISHER_NAME,EMAIL_ADDRESS,IS_ADMIN,IS_ENABLED,MAX_BUSINESSES,MAX_SERVICES_PER_BUSINESS,MAX_BINDINGS_PER_SERVICE,MAX_TMODELS FROM PUBLISHER WHERE PUBLISHER_ID=?
GetAuthTokenFunction.execute(RegistryObject) line: 91
sql is: INSERT INTO AUTH_TOKEN (AUTH_TOKEN,PUBLISHER_ID,PUBLISHER_NAME,CREATED,LAST_USED,NUMBER_OF_USES,TOKEN_STATE) VALUES (?,?,?,?,?,0,1)
BusinessLifeCycleManagerImpl.executeOperation(Object, String) line: 541
SaveBindingFunction(AbstractFunction).getPublisher(AuthInfo, DataStore) line: 73
sql is: SELECT PUBLISHER_ID,PUBLISHER_NAME FROM AUTH_TOKEN WHERE AUTH_TOKEN=?
SaveBindingFunction(AbstractFunction).getPublisher(AuthInfo, DataStore) line: 77
sql is: SELECT TOKEN_STATE FROM AUTH_TOKEN WHERE AUTH_TOKEN=?
SaveBindingFunction(AbstractFunction).getPublisher(AuthInfo, DataStore) line: 77
sql is: SELECT LAST_USED FROM AUTH_TOKEN WHERE AUTH_TOKEN=?
SaveBindingFunction(AbstractFunction).getPublisher(AuthInfo, DataStore) line: 84
sql is: UPDATE AUTH_TOKEN SET LAST_USED=?,NUMBER_OF_USES=NUMBER_OF_USES+1 WHERE AUTH_TOKEN=?
SaveBindingFunction.execute(RegistryObject) line: 90
sql is: SELECT BUSINESS_KEY FROM BUSINESS_SERVICE WHERE SERVICE_KEY=?
SaveBindingFunction.execute(RegistryObject) line: 96
sql is: SELECT * FROM BUSINESS_ENTITY e, BUSINESS_SERVICE s WHERE e.BUSINESS_KEY = s.BUSINESS_KEY AND s.SERVICE_KEY=? AND e.PUBLISHER_ID=?
SaveBindingFunction.execute(RegistryObject) line: 155
sql is: INSERT INTO BINDING_TEMPLATE (SERVICE_KEY,BINDING_KEY,ACCESS_POINT_TYPE,ACCESS_POINT_URL,HOSTING_REDIRECTOR,LAST_UPDATE) VALUES (?,?,?,?,?,?)
> Possible Juddi Performance problems
> -----------------------------------
>
> Key: JBESB-1675
> URL: https://jira.jboss.org/jira/browse/JBESB-1675
> Project: JBoss ESB
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Registry and Repository
> Affects Versions: 4.2.1
> Reporter: Tom Cunningham
> Assignee: Kevin Conner
> Fix For: 4.4
>
> Attachments: esb-util-cache-src.jar, esb-util-cache.sar, server.rar
>
>
> From forum post :
> We are not using juddi directly, I do not know if it is a core required component of ESB. After a few runs, we are having performance problems that seems to be related to juddi. It happens only on shutdow/startup operations. The time spent to create the auth tokens (sorry, what are they used for anyway??) are taking longer and longer. JBoss takes over 2 minutes (in a 8 processor machine??) just to delete the template bindings for juddi on the shutdown process.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the esb-issues
mailing list