Kbase P103395: Performance: Should the CREATE X-DOCUMENT / DELETE OBJECT pair be placed inside or outside a DO WHIL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/04/2005 |
|
Status: Unverified
GOAL:
When using a DO WHILE loop to process a list of incoming XML documents, should the CREATE X-DOCUMENT hDoc and the DELETE OBJECT hDoc statements be placed inside or outside the DO WHILE loop?
FIX:
There is no significant performance difference between the two scenarios. However, the code should run more efficiently when the CREATE X-DOCUMENT hDoc / DELETE OBJECT hDoc statement pair is placed outside the DO WHILE loop to recycle the handle within each loop.