[esb-issues] [JBoss JIRA] Commented: (JBESB-1675) Possible Juddi Performance problems

[ https://jira.jboss.org/jira/browse/JBESB-1675?page=com.atlassian.jira.plu... ] 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 (?,?,?,?,?,?) -- 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