MasterACE14 Posted August 29, 2011 Share Posted August 29, 2011 quick question, with a standard website(in my case browser text games in PHP) using MySQL. Should I be using MySQL TRANSACTIONS for any of the queries? or is the likelihood of two queries conflicting at the same time too small to worry about? Thanks, Ace Quote Link to comment Share on other sites More sharing options...
fenway Posted August 29, 2011 Share Posted August 29, 2011 That depends on the kind of queries you write. Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted August 30, 2011 Author Share Posted August 30, 2011 what about something like... UPDATE `users` SET `something`='something' in a file that is run via a cron every 30mins. A variable which the user may trigger to be updated via their actions in-game? Quote Link to comment Share on other sites More sharing options...
fenway Posted September 1, 2011 Share Posted September 1, 2011 I'm hoping there's a WHERE clause that goes along with that UPDATE. Back to your question -- it really depends on how "something" changes elsewhere in your application. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.