|
View previous topic :: View next topic
|
| Author |
Message |
ug123
Warnings : 1
New User
Joined: 01 Mar 2007
Posts: 39
Location: Chennai
|
|
|
|
Is there any possible way to retrieve all the child segments in single ims db call
The requirement is I have one root segment and 3 types of child segments under one root segment. Each child is having exactly 3 occurrences.
Normally if we want to retrieve all these occurrences we should use 10 db calls. Is there any possible way to reduce the calls.
Or can we have one db call to retrieve all the occurences of each child segment. Our ultimate aim is to reduce db calls.
Could anyone please let me know is this possible or not. |
|
| Back to top |
|
 |
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| No. |
|
| Back to top |
|
|
sambasivarao
New User
Joined: 10 Jul 2006
Posts: 47
Location: Bangalore
|
|
|
|
Hi,
I think it is possible by using Command codes we can do.
The major pupose of Command codes is to reduce the no.of calls and improve the performance.
Thanks and Regards,
Sambasiva. |
|
| Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| No - you cannot do it with command codes. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| The major pupose of Command codes is to reduce the no.of calls and improve the performance. |
Footballs do not have feathers.
Like your statement, mine is also basically true though neither has anything to do with the original question. . .
| Quote: |
| I think it is possible by using Command codes we can do. |
If you want to post a reply such as this, you need to actually test the solution on your system and post the tested result here. Untested suggestions only add clutter and are often misleading to others who read the topic later. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| dick scherrer wrote: |
| Quote: |
| The major pupose of Command codes is to reduce the no.of calls and improve the performance. |
Footballs do not have feathers. |
I'm loving it...  |
|
| Back to top |
|
|
|
|
