You need to queue the orders and process them one at a time. Read from the database only if the values have been changed. Otherwise, display it from the cache like what you've said.
What bothers me is that, one of the core features of the game will be trade, and with that you need a market place with lists of buy and sell orders. These will need to be kept up to date and every time the user visits the 'market.php' page it will have to do a search query and update it accordingly. I'm worried this could take very long and by the time the user chooses to buy or sell something, the data has changed and they'll get the wrong order when they submit.
zonewebMember Since 08 Mar 2012
Offline Last Active May 23 2013 12:54 AM
- Group Members
- Active Posts 18
- Profile Views 592
- Submitted Links 0
- Member Title Member
- Age Age Unknown
- Birthday Birthday Unknown
computer programming, digital art, swimming, hiking