| Author |
Message
|
| sourdas2 |
 Posted: Tue Feb 20, 2007 11:22 pm Post subject: ESQL Performance - While Loop V$ Recursive function |
 |
|
Voyager
Joined: 21 Apr 2006
Posts: 90
Location: Kolkata,India
|
I am using WBIMB V6.0.
My input sample XML is like
| Code: |
<ROOT>
<ABC>[1-N] - 1st level
<ABC>[1-N] - 2nd level
<ABC>[0-N] - 3rd level
<ABC>[0-N] - 4th level.....upto this level of <ABC> occrance
|
Can anybody suggest - which is the better approach of esql coding in terms of performance issue - four While loops with a common procedure or a recurcive procedure.
_________________
Thanks and Warm Regards
Sourav |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Tue Feb 20, 2007 11:31 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
I don see much of performance difference over here....
Though i would prefer recursive procedure as a good coding practise.
_________________
Cheers |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Feb 20, 2007 11:57 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi sourdas2,
I would prefer loops(using references)....Doing a WHILE is much better, than calling a procedure again and again, where it will create its own new references every time you call it, plus check your INs,OUTs and INOUTs...
I won't say that the difference would be large...but still...
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Feb 21, 2007 3:22 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I'd prefer the solution that fit the requirements best, and was the most maintainable.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| au@kosa |
| Posted: Wed Feb 21, 2007 4:37 am Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
If you are planning to pass so many arguments to a procedure do not use recursive method i will prefer while loop. If your passing one or two parameters you can think of using recursive approach. In this case performance impact will be less.
Regds,
Amit Upadhyaya |
|
| Back to top |
|
|
|
|
