I have a program which inserts a few thousand records into a table. At some point here and then it has to update a lookup table and this update has to be committed before the main update loop continues. As far as I understand, the update/commit of the lookup table also commits all updates of the main table. Is there a way to do commits only for distinct tables?
