Skip to Content
avatar image
Former Member

How to optimized the performance of 'Nest' in BODS

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers