[ https://jira.jboss.org/jira/browse/JBESB-3307?page=com.atlassian.jira.plu... ] Kevin Conner commented on JBESB-3307: ------------------------------------- Two issues addressed by this, one in scout and one in juddi - BusinessQueryManagerImpl->findServiceBindings in scout This method loads the service bindings and, for each binding, then reloads the service from the database. This then reloads different information about the bindings. - JDBCDataStore->fetchService in juddiv2 This method retrieves details of a service plus all its bindings. In retrieving the binding information it makes a single query which returns most of the information (all of the relevant information for ESB) but then throws that away and makes multiple (min 5) queries for each binding associated with that service. The combination of both these issues leads to an explosion in the number of queries executed on the database if services have multiple bindings registered. -- 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

[ https://jira.jboss.org/jira/browse/JBESB-3307?page=com.atlassian.jira.plu... ] Kevin Conner reopened JBESB-3307: --------------------------------- Sorry, forgot one file during check in. -- 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