> But perhaps it would be a good idea to commit and reopen that
> transaction once in a while, perhaps once each night or once an hour?

Why ? It would just make the program more complex without good reason.

Ivan