Hi, I would like to ask you a few question that have me real puzzled :/
ok
1. 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
??
2. 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
ok
1. 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
??2. 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
Comment