April 12, 2017 in Feedback
I'm pretty sure that IPS4 is not transaction safe when using MySQL INNODB engine. I require transactions to prevent database corruption and replication.
Could this feature be implemented by:
Existing applications wouldn't need to do #3 since all changes would be committed automatically, but updated applications could handle errors or commitment points better (on a transaction level, not just a statement level). The DB class could default to the current behavior unless a new sql_autocommit setting is set to 0.
You may even be able to avoid doing #3 if the DB class can tell whether the current page is successfully completing (COMMIT issued) or resulting in an error (ROLLBACK issued).
This would result in any changes required by this feature to be limited to IPS4 Core components only.
This topic is now archived and is closed to further replies.
Started 22 hours ago
Started November 19, 2020
Started 41 minutes ago