Why External Sort is more efficient than Internal sort?

Showing Answers 1 - 8 of 8 Answers

srilkrishy

  • Aug 28th, 2006
 

Hi,

For internal sort,you need to code a program by specifying the sort criteria and that the program need to be compiled and linked.

But in case of External sort,there is no need for coding the program.Moreover you can change the sort criteria just by changing the sort parameters that passed thru the SYSIN card.

So the external sort is more efficient compared to internal sort.In case of internal sort,if you want to modify the SORT criteria,you need to repete the entire procees of changing the program,compile and linking it.

Thank you

Krishy

  Was this answer useful?  Yes

rajesh

  • Aug 31st, 2006
 

Hi,

For internal sort,you need to code a program by specifying the sort criteria and that the program need to be compiled and linked.

But in case of External sort,there is no need for coding the program.Moreover you can change the sort criteria just by changing the sort parameters that passed thru the SYSIN card.

So the external sort is more efficient compared to internal sort.In case of internal sort,if you want to modify the SORT criteria,you need to repete the entire procees of changing the program,compile and linking it.

rajesh

  Was this answer useful?  Yes

jayakumar

  • Sep 9th, 2006
 

What you said is ok,but what is the real reason of using the internal sort,at which time the internal sort (PLISRTA) is really needed?

  Was this answer useful?  Yes

HEMANTKUMAR BPRASE

  • Sep 16th, 2006
 

external sort is more efficient than internal b'coz it is faster process. it takes less time.

  Was this answer useful?  Yes

manoj

  • Sep 28th, 2006
 

 There are two ways to do sorting :

 1. Cobol program - sort statement

2. using JCL

 sorting using cobol prog called as internal sort and sorting using jcl called as external sort.

 Offcourse , External sort is better because we can sort a file in 4 steps only. In internal sort we have to write complex code.

 As a programmer i use short cut method but it depands upon the work.

thanks

manoj.

  Was this answer useful?  Yes

memays

  • Nov 11th, 2007
 

Technically, an External sort is more efficient and can utilize I/O slighltly better than an internal sort, however in a typical environment, files are sorted so they can be input to another program which requires them to be in a specific sequence.

The External sort would require the file to be passed 3 times:   Input to Sort, Output from Sort, Input to program that passes the data.

An Internal sort will only require the file to be passed 1 time: Input to application with Internal sort.
 
When taking this into consideration, from an overall processing efficiency viewpoint, the INTERNAL sort would be much more efficient, as the difference in sorting speed would be more than offset by the time it would take to read/write/read the file using an external sort.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions