DSXchange

I'm still going to say that increasing the size doesn't really 'improve performance' per se unless perhaps your data was not fitting in the cache and thus not cached at all. It would allow your data to be cached (and remove the warnings Ray mentions) but if it is already cached and you just make the...

Your problem is more than likely the 'from a file' part... what syntax are you using for that? Also curious if there any parameters in the file.

Personal opinion - that's not the right place to be doing that.

Yup, fork that join.

qt_ky wrote:I'm not sure we're looking at the same post.

We are, sorry... having a bit of a brain fart trying to squeeze answers in between real work and not having access to my docs. More later when the codeine wears off and I try to get my crazy train back in the rails.

Sure... was addressing the posted question of the hashed file size, there wasn't any mention of the actual read/writing caching options. There are a small number of situations where you wouldn't have read caching turned on and that's on by default from what I recall. Write caching on the other hand ...

Is there any particular reason you aren't upgrading to something more... recent?

The first one has nothing to do with performance as far as I know. Row Buffering does, of course but IMHO it is something you really need to understand pro v. con before you just turn it on.

The first one has nothing to do with performance as far as I know. Row Buffering does, of course but IMHO it is something you really need to understand pro v. con before you just turn it on.

The Default project setting for Read and Write Cache is 128 MB. Does changing value higher, say to 256 MB, assist in improving job performance that are reading or writing to a Hashed File? No. In all my born Server days, I don't recall ever needing to change that. Except maybe once and I no longer ...

In other words, spell it out in words - don't just simply show us the before and after and make everyone here try to puzzle it out. Are you sure it shouldn't be? 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, P 20, P,Q 20, P,Q,R 20, P,Q,R,S Or perhaps: 10, A,B,C,D 20, P,Q,R,S Only the latter answer makes s...

What kind of 'comparison' are you attempting? I would imagine you could convert both the strings in a common format and then compare those.

qt_ky wrote:I thought that the NLS setting was an install-time only decision. See what others say and/or contact Support.

It basically is... see Ray's simul-post.

Why don't we start with - what problem are you trying to solve? The 'compile error' in the technote and you believe your Stage Types hashed file may be corrupt?

Server jobs... no peeking. Instead you would set a constraint of @FALSE in the output link of the transformer if you were trying to gauge extraction speed alone.

Well... not exactly what I meant. Your earlier trigger conditions should have been fine if you just added the redirect of stderr to the first command, the one throwing errors when no file exists. One variation: ls -lrt /Path/*ABC*.xml 2> /dev/null | wc -l That would suppress the 'No such file or dir...