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 Link to comment https://forums.phpfreaks.com/topic/245942-quick-question-transactions/ 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. Link to comment https://forums.phpfreaks.com/topic/245942-quick-question-transactions/#findComment-1263152 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? Link to comment https://forums.phpfreaks.com/topic/245942-quick-question-transactions/#findComment-1263457 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. Link to comment https://forums.phpfreaks.com/topic/245942-quick-question-transactions/#findComment-1264289 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.