Subject Re: [IBO] fastest IB_Cursor... how???
Author Helen Borrie
At 10:10 AM 7/09/2006, you wrote:
>At 05:22 PM 9/6/2006, you wrote:
> >Your example seems to suggest that you are re-using the same
> >IB_Cursor object for different statements. If so, your function
> >should clean up after it has finished reading the value.
>A very elementary question: What exactly does "clean up" mean? Call


>Anything else?

Close the cursor first then unprepare it. Next time it would be
used, invalidating the SQL would unprepare it any case; but, in the
meantime, it is untidy practice to keep a set prepared if you're not
planning to re-use it soon. It's one more piece of stuff that would
have to be taken care of by the server if, say, the connection was
broken; and it's not useful to have the server holding resources
unecessarily; and, if it is in a read-write transaction, it will hold
up garbage collection.