Re: Question about opening and closing files

[Buck <kc2hiz@xxxxxxxxx>]

James Lampert wrote:
> How much overhead would you say is involved in making files *USROPN, and
> keeping them open only while actually performing I/O on them, as opposed
> to doing things the usual way?
>
> We're thinking of doing this in a trigger program, in order to cut back
> on the number of file locks.

If you're looking to do multiple OPEN / CLOSE cycles, the normal
mitigation (shared ODP) won't be useful for your goal of reducing locks.
 You'll need to weigh the expense of multiple OPEN / CLOSE cycles
against the lock situation.

For what it's worth, I haven't personally seen a user OPEN as more
expensive than letting the cycle do it.