Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Which of the following is more TIME EFFICIENT??

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
baldi

New User


Joined: 16 Jun 2005
Posts: 13
Location: Amsterdam

PostPosted: Tue Nov 29, 2005 3:21 pm    Post subject: Which of the following is more TIME EFFICIENT??
Reply with quote

Situation A : One program needs different data from 100 different tables. For modularity sake programmer has made one dataservice for each table, and hence it makes 100 calls to these 100 dataservices to fetch the required data.

Situation B : There is only one dataservice which will go to all these 100 tables and fetch the required data, so now main program has only single call.

Now please consider following arguments :
1. Depending upon the input given, main program will at maximum need to fetch data from 10 tables with a given set of input data.

2. Load module size of single dataservice of Case B will be much larger
than dataservice of case A. So more MAIN MEMORY will be required and loading will also take more time.

3. But as all the calls are dynamic in nature, call reslution takes place during run time, so calling time of case B will be lesser as there is only single call.

Please assume things from your experience if some data is missing.
Thanks
Back to top
View user's profile Send private message

mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Fri Dec 16, 2005 7:22 am    Post subject:
Reply with quote

baldi,

There is no straight forward answer to your query...! Both the cases have its merits and demerits...

The performance would also depend on the following:

1) Types of queries (simple or join or union)
2) Number of rows fetched by queries (singleton select or in a cursor)
3) Indexes defined on the tables

Hopes this helps

Regards
Mayuresh
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Fri Dec 16, 2005 11:52 am    Post subject: time
Reply with quote

Hi frnd,
V can't say the exact solution.. each of ur situation differs.. and it takes time accrodingly.. so as per mayuresh said.. all has it's own time execution and nothing depends on one another..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Full Time COBOL Software Development ... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:24 am
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 2 Thu Jan 19, 2017 1:31 am
No new posts DD DUMMY & CPU TIME Nileshkul Testing & Performance analysis 16 Mon Dec 19, 2016 11:35 pm
This topic is locked: you cannot edit posts or make replies. Get a job submitted itself every time... arunsoods JCL & VSAM 3 Tue Nov 22, 2016 4:05 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us