Autocommit vs. Single Transactions (Small Project vs. Big Project)?

MyISAM is transactionless, so autocommit does not affect it.

MyISAM is transactionless, so autocommit does not affect it. As for InnoDB, autocommit makes repeating queries hundreds of times as slow. The best decision is of course doing everything set-based, but if you have to do queries in a loop, turn autocommit off.

Also note that "multiple queries" and "doing many things in one query with JOIN" are completely different things. The latter is an atomic operation which succeeds or fails at once even on MyISAM. Autocommit does not affect its performance as such: everything inside this query is always done in a single transaction.

Doing many things in one query is actually a preferred way to do many things.

Joins are not just useful they are necessary in any but the simplest of datastructures. To consider writing without them shows a fundamental lack of understanding of relational database design and access to me. Not to use joins would usually result in getting the wrong answer to your question in a select.

You may get away without joins in inserts, updates and deletes, but they are often used and useful there as well.

1 if I could, thank you very much. – daemonfire300 Oct 13 '09 at 20:08.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.