Uploaded image for project: 'jUDDI'
  1. jUDDI
  2. JUDDI-573

Performance Issue fetching business

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.3
    • Fix Version/s: 3.1.5
    • Component/s: core
    • Labels:
      None

      Description

      I've set up juddi with 62 businesses with 100 services each and I've ran into some pretty serious performance issues and even a bizarre stack trace. It takes over 40 seconds to fetch 20 business at a time using find_businesses with a '%' approximateMatch qualifier.

        Issue Links

          Activity

          Hide
          kurtstam Kurt T Stam added a comment -

          A find_business should return a list of businessInfos, which contains serviceInfos. So this can result a quite a few queries. Let's make sure we are not doing more work then needed, and if we don't, let's see if we can maybe optimize the query a bit; and make sure we have indexed the right columns.

          Show
          kurtstam Kurt T Stam added a comment - A find_business should return a list of businessInfos, which contains serviceInfos. So this can result a quite a few queries. Let's make sure we are not doing more work then needed, and if we don't, let's see if we can maybe optimize the query a bit; and make sure we have indexed the right columns.
          Hide
          kurtstam Kurt T Stam added a comment -

          fixing performance issue while querying for busineses with lots of services. There is no need o re-query each service in this case. This optimization brought the query time down to less then 1 second.

          Show
          kurtstam Kurt T Stam added a comment - fixing performance issue while querying for busineses with lots of services. There is no need o re-query each service in this case. This optimization brought the query time down to less then 1 second.

            People

            • Assignee:
              kstam Kurt T Stam
              Reporter:
              spyhunter99 Alex O'Ree
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development