View previous topic :: View next topic
|
Author |
Message |
baldi
New User
Joined: 16 Jun 2005 Posts: 13 Location: Amsterdam
|
|
|
|
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 |
|
|
mdtendulkar
Active User
Joined: 29 Jul 2003 Posts: 237 Location: USA
|
|
|
|
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 |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
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 |
|
|
|