Duration of an open operation on a smart large object

After you open a smart large object with the ifx_lo_create() function or the ifx_lo_open() function, it remains open until certain events occurs.

A smart large object remains open until one of these events occur:
  • The ifx_lo_close() function closes the smart large object.
  • The session ends.
Important: The end of the current transaction does not close a smart large object. It does, however, release any lock on a smart large object.

Close smart large objects as soon as you finish with them. Leaving smart large objects open unnecessarily uses system memory. Leaving many smart large objects open can eventually produce an out-of-memory condition.