Skip to Content

How to optimized the performance of 'Nest' in BODS

Aug 14, 2017 at 09:29 PM


avatar image
Former Member

Hi there,

I'm developing a dataflow which need to apply a function and the function use

a table as input parameter. I used a SQL transform to extract the table and then query it as 'Nested with sub-schemas'. And next, apply the function and use the nested table as one of input parameter. This dataflow got work for extracting small amount of rows. However, the performance is super bad for thousands rows. From the monitor, I saw that tons of time is consumed in 'Nested' step. So, I wonder if someone know how to optimize that step?

Thanks in advance!

dra1.jpg (101.4 kB)
dra2.jpg (22.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers