Hi, I would like to ask you a few question that have me real puzzled
- what’s the real use of one transaction? and its advantages and disadvantages…
I wonder this because I have a game with multiple users and a lot of updates are going every second…BUT how do I know if a certain transaction went wrong (in this case I should apply ROLLBACK;) or was a sucessful update (COMMIT;)??
- what’s the main difference and what would you recommend me to use as an engine…innoDB or myISAM?? I know innoDB support transactions but…what’s the wrong side?? what are the advantages and disadvantages, specially for me that I usually don’t know if a valid query is being performed (it should be, as my game in 6 months has no created any problem, but I’m trying to create a new one but more and more things about performance are coming to my head and I don’t know what’s really good)
any help will be really welcomed
thanks in advance )
btw if you would like to check the game I’m talkin’ about if you like to have a better grasp you can find it at vaperida dot com