Hello everyone, We can find at mysql documentation, that using transaction may slow down up to 4 times mysql. This because working with transfaction means to do a lot of things while updating tables. I'm currently working in a system where in some cases (very few cases) I realy need to use transactions. So, only in those cases I use transaction tables (Innodb). And also, I still work in autocommit mode. Only when I need transaction I use BEGIN/COMMIT/ROLLBACK.
My question is, am I improving performance with that? Or just by using the transaction tables it means my performance will go down anyway? Also, working without transaction (autocommit) in transaction tables whenever possible makes any difference? Thanks a lot, Joao. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
