Hi everybody,
I'm wondering several things about this option :
1. Is it the size of the array returned by the "tOracleInput" query at one time so that we can perform operations on several rows at one time ? (Is it an Oracle functionnality ?)
2. I've noticed that if I put a cursor or 1 row, I get lower performances. What's the default value ?
3. There is not such an option on files. Does it mean TOS treats only one row each time ?
Hi everybody, 3. There is not such an option on files. Does it mean TOS treats only one row each time ? Nicolas
I think you should use a "iterate" link and activate parallel execution. I also think parallelism in iterate links is different from job parallel execution.
Infact i use a simple cache mechanism implemented inside the custom java classes. It is used in fields filled with few possible values, i.e. not to execute a SELECT statement at each row. It is a pity I can't use it everywhere, as it causes thrashing..
What's this cache system ?
Hi everybody, 3. There is not such an option on files. Does it mean TOS treats only one row each time ? Nicolas
I think you should use a "iterate" link and activate parallel execution. I also think parallelism in iterate links is different from job parallel execution.
Iterate link is not usable everywhere. It's useful to perform one computation for each result you get of action performed by a component. However, you cannot perform some operations on a data flow with an iterate link.
But I think you meaned at the top of my job. I'm experimenting it but I do not obtain so much improvement for the moment... Trying to find why.
Best regards,
Nicolas
