Ventajas y desventas del uso de Transaction().connection.commit()

Buen día

Hace un tiempo buscaba como ir agregando los registros creados sin tener que esperar que finalice la transacción, para esto me recomendaron el uso del commit pero me quedó la duda de que ventajas y desventajas pueden tener el uso de este.

Records are created as soon as they are saved. It is not required to make a commit. Indeed it is most of the time a very bad idea to call yourself commit because you can leave the application in non-coherent state in case of error later (for which everything done before the commit will be stored).
Of course the new records exist only for the current transaction until the transaction finish successfully. Then the records will be visible to any new transaction started after.