GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Mainframe
Go To First  |  Previous Question  |  Next Question 
 Mainframe  |  Question 22 of 55    Print  
Why External Sort is more efficient than Internal sort?

  
Total Answers and Comments: 6 Last Update: November 11, 2007     Asked by: Prasad 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 28, 2006 15:48:09   #1  
srilkrishy Member Since: May 2006   Contribution: 5    

RE: why External Sort is more effiecient than Internal...

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


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
August 31, 2006 08:55:12   #2  
rajesh        

RE: why External Sort is more effiecient than Internal...

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


 
Is this answer useful? Yes | No
September 09, 2006 10:20:10   #3  
jayakumar        

RE: why External Sort is more effiecient than Internal...
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?
 
Is this answer useful? Yes | No
September 16, 2006 07:22:26   #4  
HEMANTKUMAR BPRASE        

RE: why External Sort is more effiecient than Internal...
external sort is more efficient than internal b'coz it is faster process. it takes less time.
 
Is this answer useful? Yes | No
September 28, 2006 06:13:02   #5  
manoj        

RE: why External Sort is more effiecient than Internal...

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.


 
Is this answer useful? Yes | No
November 11, 2007 19:05:30   #6  
memays Member Since: November 2007   Contribution: 5    

RE: Why External Sort is more efficient than Internal ...
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.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape