SMP to MPP Systems

scorpion · Post by **scorpion** » Mon Apr 16, 2007 1:32 am

Hi All,

I am just curious to know that,

1)What will be happens, if we run the jobs on MPP systems,which are created on SMP systems.

2)My dev box is on SMP System and if I move my production server to MPP Systems,what will be happens?means does it affects our individual job behavior or decreasing performence..etc.

Thanks in advance

ArndW · Post by **ArndW** » Mon Apr 16, 2007 6:29 am

How jobs are run using Enterprise Edition depends upon how the configuration files are set up. Unless you configure specifically for distributed processing jobs written on a SMP box but run on another system and using the same configuration files will run just the same way.

arnabdey · Post by **arnabdey** » Mon Apr 16, 2007 9:11 am

There should not be any change in your job design. It's all upto the configuration file specified by the APT_CONFIG_FILE parameter.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 16, 2007 3:34 pm

As a general rule, there will be no impact. The only major exception is if your designs involve a lot of repartitioning, which means that rows have to move between player processes on different processing nodes. In an SMP environment this is managed through shared memory; in an MPP environment the mechanism is the necessarily slower TCP sockets. The "solution" is to create job designs that minimize the amount of repartitioning performed.