Skip to main content
Question

ListBuilder Input is Ordered by Group

  • May 5, 2017
  • 6 replies
  • 27 views

jdh
Contributor
Forum|alt.badge.img+40

Has anyone else noticed a significant decrease in performance when using the ListBuilder Input is Ordered by Group?

When I have 100,000 features in 10,000 groups of 10 features each, when I set the Input Is Ordered to no, the processing time is 8 seconds, even though the transformer is blocking. Whereas when set it to Ordered by Group, the processing time is 74 seconds (almost 10x slower), even through the transformer is non blocking.

No parallel processing is involved.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

6 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • May 5, 2017

I assume the data is actually ordered the right way. If not this is easily explained as it would create too many lists.


jdh
Contributor
Forum|alt.badge.img+40
  • Author
  • Contributor
  • May 5, 2017

I assume the data is actually ordered the right way. If not this is easily explained as it would create too many lists.

The data is correctly ordered.

 

 


jdh
Contributor
Forum|alt.badge.img+40
  • Author
  • Contributor
  • May 5, 2017
Both options produce identical results, though the Ordered: No option has a much higher peak memory consumption. Which is not unexpected.

 

 


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • May 5, 2017
The data is correctly ordered.

 

 

I figured it would be.

 

 


fmelizard
Safer
Forum|alt.badge.img+21
  • Safer
  • May 7, 2017

I smell a bug. I know that for some processing functions when we turn on "ordered by group" another layer is added above the actual processing unit (factory in old school FME lingo). That must be causing this. I just verified this and will have a ticket/case created. In my case it goes from 2.6 seconds when we don't order by group to 77 seconds when you do. Not much of an optimization:-)


fmelizard
Safer
Forum|alt.badge.img+21
  • Safer
  • May 7, 2017

I smell a bug. I know that for some processing functions when we turn on "ordered by group" another layer is added above the actual processing unit (factory in old school FME lingo). That must be causing this. I just verified this and will have a ticket/case created. In my case it goes from 2.6 seconds when we don't order by group to 77 seconds when you do. Not much of an optimization:-)

listbuilderorderedby.fmw in case anyone wants to try this at home...