Transaction Rollback Performance

[eluser]verynewtothis[/eluser]
My suggestions:
Move your transaction commands to the model function.
Try having least number of programming logic in between the start and end transaction commands.. have your data prepared inside your controller (prior to sending it to the model) rather then doing it inside the transaction start/end commands... enabling "profiling" can also provide some useful information about time it takes to execute query etc..