DSXchange

Got it...thanks

Thanks lots! I'll check it out.

Again, thanks so much for your explanations! I learned a lot from your contributions to this thread :D It would appear that your system has 64BIT_FILES enabled in uvconfig; this is an inefficient setting, as it forces all hashed files, including the small ones in the Repository, to have 64-bit inter...

It sure has Thanks for your help!

Magic!!! It worked! I'm now getting 13k rows/sec! That was indeed THE problem! :mrgreen: Thanks so much for your (ArndW, Ray, and Ross) wonderful help! Really appreciate it! If you happen to go pass Melb, let me know so I can buy you coffee or beer :) If you go to your ADMINistrator tool and execute...

Thanks for the info! I only used DS for 1.5 weeks so far...How can I clear this file? I didn't create this file myself...suppose it was created by the transform procedures? If you don't need the unique key values generated thus far (i.e. you are in DEV and not PROD) then you can CLEAR.FILE this file...

Here are the results... A quick test would involve the following commands, issues from the Administrator client Command window, or from the dssh environment on the server. COUNT SDKSequences 40310 records counted. FILE.STAT SDKSequences File type = 2 Number of groups in file (modulo) = 1 Separation ...

They look like the genuine routines - the only difference is that one hangs on to the lock (via WriteU) while the other releases it (Write). No indication why this might create slowness - most users have found this to be an adequately fast mechanism. Thanks for reviewing this! Now I'm really curiou...

This is the code I see in our dev repository... First sdk transform routine is called "KeyMgtGetNextValue", takes one argument.. ************************************************************************* * Copyright (C) 2003, 1997-2002 Ascential Software Corporation. All Rights Reserved. * ...

Thanks very much for that! I'll check the routines we have here on Monday. Much appreciated!

Can you email me your version? Or would you like me to email you my version? Pls advise. Thanks! Has some kind soul modified your KeyMgt routine? (There was one group of consultants running around Australia and New Zealand doing that for some years - rebadged the SDK routines as their own, and manag...

18 columns in total (approx 4-20 varchar for every column). Once I remove the KeyMgt transform, it runs at a few k rows/sec....hence my initial question about KeyMgt performance... 3 to 4 rows per second is not normal. I suspect something is wrong. From Sequential to Sequential without having any co...

I tried a simple server job SEQ FILE A --> TRANSFORM --> SEQ FILE B The TRANSFORM contains a direct map between A and B columns except the last numeric column is set to use KeyMgtGetNextValue('atest') instead of the input. The speed I'm getting is 3~4 rows/sec with a stop limit at 5k rows... Am I do...

I didn't go through it in detail. Thanks for the reminder!

Where did you read that? Can you provide the link here? :?: From what I've tested, I would say KeyMgt is much slower than @OUTROWNUM or DB key generation functions... [quote="balajisr"]Keymgt functions uses common blocks. I read that it is better to avoid common blocks. Does this also impl...