task #4911: improve performance of distributionInfoFor service - EDIT - EDIT Project Management

Actions

task #4911

open

improve performance of distributionInfoFor service

Added by Andreas Kohlbecker almost 8 years ago. Updated about 1 year ago.

Status:

In Progress

Priority:

Highest

Assignee:

Andreas Müller

Category:

cdmlib

Target version:

Start date:

Due date:

% Done:

0%

Estimated time:

Severity:

normal

Tags:

performance euro+med

Description

currently the distributionInfoFor service call is the slowest request for a lot of portals to build up the taxon general page:

for example euro+med Bellis perennis: http://160.45.63.175/cdmserver/euromed/portal/description/distributionInfoFor/0eb6ca37-3365-4af5-a800-8fc4b8c366fa.json?statusOrderPreference=1&subAreaPreference=1&hideMarkedAreas=ae7874dd-374d-4ba2-89a2-90bfd5e35305&part=mapUriParams&part=tree&omitLevels=38efa5fd-d7f0-451c-9de9-e6cce41e2225&statusColors={%0D%0A++++%22p%22%3A+%22%239CDF00%22%2C%0D%0A++++%22n%22%3A+%22%23008000%22%2C%0D%0A++++%22nd%22%3A+%22%2300FF00%22%2C%0D%0A++++%22nq%22%3A+%22%2300c8b4%22%2C%0D%0A++++%22f%22%3A+%22%23FFFFFF%22%2C%0D%0A++++%22in%22%3A+%22%23C86400%22%2C%0D%0A++++%22i%22%3A+%22%23C89600%22%2C%0D%0A++++%22ip%22%3A+%22%23C89600%22%2C%0D%0A++++%22ia%22%3A+%22%23c8c800%22%2C%0D%0A++++%22iq%22%3A+%22%23ffc896%22%2C%0D%0A++++%22c%22%3A+%22%23ffff00%22%0D%0A} takes 8.416s 2015-05-18 see also git tag 2015-05-18_01

possible improvements:

avoid term loading in web service controllers, this may be caused by making use of the TermBaseListPropertyEditor
avoiding second distribution filtering when creating the DistributionServiceRequestParameterString, see comment 3

Related issues

Actions

#1

Updated by Andreas Kohlbecker almost 8 years ago

Status changed from New to In Progress

Actions

#2

Updated by Andreas Kohlbecker almost 8 years ago

improvments implemented:

r23851, r23844, r23840,

See also the related improvements made at the AdvancedBeanInitializer #4919#note-1

Actions

#3

Updated by Andreas Kohlbecker almost 8 years ago

Target version changed from cdmlib RELEASE 3.5.2 to Release 3.7

this was not closed in Release 3.5.2

Applying another improvement which is only in git at the moment: d798947 (UPDATE: pushed ans now also in svn as r24421) - avoiding second distribution filtering when creating the DistributionServiceRequestParameterString

Actions

#4

Updated by Andreas Müller over 7 years ago

Target version changed from Release 3.7 to Release 3.8

Actions

#5

Updated by Andreas Kohlbecker over 7 years ago

Target version deleted (~~Release 3.8~~)

moving unresolved tickets to next milestone after release of 3.8.0

Actions

#6

Updated by Andreas Müller over 7 years ago

Target version deleted (~~Release 3.12~~)

Actions

#7

Updated by Andreas Müller almost 7 years ago

Target version changed from Release 4.0 to Release 4.1

Actions

#8

Updated by Andreas Müller almost 7 years ago

Target version changed from Release 4.1 to Release 4.2

Actions

#9

Updated by Andreas Müller over 6 years ago

Target version changed from Release 4.2 to Release 4.3

Actions

#10

Updated by Andreas Müller over 6 years ago

Target version changed from Release 4.3 to Release 4.4

Actions

#11

Updated by Andreas Müller over 6 years ago

Target version changed from Release 4.4 to Release 4.5

Actions

#12

Updated by Andreas Müller about 6 years ago

Target version changed from Release 4.5 to Release 4.6

Actions

#13

Updated by Andreas Müller about 6 years ago

Target version changed from Release 4.6 to Release 4.7

Actions

#14

Updated by Andreas Müller almost 6 years ago

Description updated (diff)
Private changed from Yes to No

Actions

#15

Updated by Andreas Kohlbecker almost 6 years ago

Target version changed from Release 4.7 to Release 4.8

Actions

#16

Updated by Andreas Müller over 5 years ago

Target version changed from Release 4.8 to Release 4.9

Actions

#17

Updated by Andreas Müller over 5 years ago

Target version changed from Release 4.9 to Release 4.10

Actions

#18

Updated by Andreas Kohlbecker over 5 years ago

Target version changed from Release 4.10 to Release 4.11

Actions

#19

Updated by Andreas Müller over 5 years ago

Target version changed from Release 4.11 to Release 4.12

Actions

#20

Updated by Andreas Müller over 5 years ago

Target version changed from Release 4.12 to Release 4.13

Actions

#21

Updated by Andreas Müller about 5 years ago

Target version changed from Release 4.13 to Release 4.14

Actions

#22

Updated by Andreas Müller about 5 years ago

Target version changed from Release 4.14 to Release 5.0

Actions

#23

Updated by Andreas Kohlbecker almost 5 years ago

Target version changed from Release 5.0 to Release 5.1

Actions

#24

Updated by Andreas Kohlbecker almost 5 years ago

Tags changed from performance to performance, euro+med
Assignee changed from Andreas Kohlbecker to Andreas Müller
Target version changed from Release 5.1 to Release 5.2

Hi Andreas, I am passing this issue to you, since you are in the euro+med sprint, ähhh, long-distance run!

Actions

#25

Updated by Andreas Müller over 4 years ago

Target version changed from Release 5.2 to Release 5.3

Actions

#26

Updated by Andreas Müller over 4 years ago

Target version changed from Release 5.3 to Release 5.5

Actions

#27

Updated by Andreas Müller about 4 years ago

Target version changed from Release 5.5 to Release 5.6

Actions

#28

Updated by Andreas Müller about 4 years ago

Priority changed from New to Highest
Target version changed from Release 5.6 to Reviewed Next Major Release

Actions

#29

Updated by Andreas Müller over 2 years ago

Related to feature request #9271: Improve E+M dataportal performance added

Actions

#30

Updated by Andreas Müller about 1 year ago

Target version changed from Reviewed Next Major Release to Release 5.37

Actions

#31

Updated by Andreas Müller about 1 year ago

Related to task #9524: Use non-model objects in database queries for getDistributionInfoFor added

Actions

Also available in: Atom PDF