AndrewB wrote:I am surprised (and scared) to hear, that CC does not really have a constantly running engine, independent from the php front end. You might want to rethink the architecture for the game. Cause i think even with 500 users, it will be crawling in the current scenario...
Possible improvements which will speed up the site are:
1. Pull out the business logic into separate application (ie. Windows Service if u are using Windows hosting environment)
2. Use AJAX in the game space.
3. OR use flash in the game space.
Well I do have a constantly running engine... the database! It's eating up more CPU power than the business logic right now (or so it seems). Since things have definitely been slower lately, I spent the last few days setting up caching - for the RSS, map armies and even PHP opcode. Also got in touch with the hosting company to get a quote for a dedicated server. Because I'm going to run out of things to tweak.
As for architecture, AJAX is a top priority for 2007. It will be key for the realtime game experience and should drastically cut bandwidth. Will it reduce the load on the database? We'll see. Flash is outta the question - I want a low-tech, server side web game. And so is anything Windows, because I don't like Micro$oft!
Of course I could also forget all this and whip my girlfriend a little harder (off camera of course

)