Published on InterSystems Developer Community (https://community.intersystems.com)

Home > What is the impact of not "closing" queries, when using the%Resultset library?

Question
VICTOR GALVAO · Sep 15, 2020

What is the impact of not "closing" queries, when using the%Resultset library?

Hi guys!!

In the system that I work, I came across an iterator pattern that uses the %Resultset library without performing the close after executing the query. Does anyone know how to say what are the impacts of not performing such a procedure?

If you have any model of iterator pattern made in caché to recommend as a good example, I will be grateful hehe  :D

#ObjectScript #SQL #Caché

Source URL:https://community.intersystems.com/post/what-impact-not-closing-queries-when-using-theresultset-library