How to optimized the performance of 'Nest' in BODS

[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!