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 |
|
 |
|