Hmm nope but it is not a million miles away from me here in Somerset. -----Original Message----- From: flashcoders-boun...@chattyfig.figleaf.com [mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Glen Pike Sent: 22 April 2009 12:41 To: Flash Coders List Subject: Re: [Flashcoders] Feasibility of xml file for high score data storage
Not working for Cornwall County Council by any chance??? :) Paul Steven wrote: > Thanks Glen and Ian > > Yes I am currently using a mysql database while the high scores are hosted > on my site. The game is for a rather large organisation so it is not the > easiest task in the world getting a database set up at their end. The > mention of flash alone was enough to cause major panic so you can imagine > the fear when I mentioned the need to upload php files to their server:) > > Cheers > > Paul > > -----Original Message----- > From: flashcoders-boun...@chattyfig.figleaf.com > [mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Glen Pike > Sent: 22 April 2009 12:15 > To: Flash Coders List > Subject: Re: [Flashcoders] Feasibility of xml file for high score data > storage > > I am guessing that any server side code to update the XML file will rely > on the server to "lock" files, etc. > > Databases are often optimised to allow for multiple "clients" to update, > but most file based commands will lock the file preventing access by > other "clients" so if your code throws a wobbly rather than waiting, > that could be a problem... > > Saying that, you could look at using SQLLite for example - this uses a > file based database, but your SQLLite "engine" will handle all of the > access - a lot of PHP installations come with this nowadays and ASP code > also uses ADOBC to connect to Access database files so you will have a > similar system. > > The upshot is that using a server side database engine will make life > easier because they will deal with problems like concurrent connections > for you :) > > Glen > > Paul Steven wrote: > >> I was considering using an xml file to store high score data for a game. >> > It > >> is quite possible that this game will have a significant amount of traffic >> (certainly in the first few days after launch) and I am now wondering if >> > an > >> xml file would be suitable. I am not sure what happens in the scenario >> > where > >> multiple players want to update the highscore at the same time - they will >> all need to write to the file. I assume this is the same scenario with a >> database but think perhaps updating a database is more efficient. >> >> Anyone care to offer any insight into whether an xml file would be >> > suitable > >> or not? >> >> Thanks >> >> Paul >> >> _______________________________________________ >> Flashcoders mailing list >> Flashcoders@chattyfig.figleaf.com >> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders >> >> >> >> > > _______________________________________________ > Flashcoders mailing list > Flashcoders@chattyfig.figleaf.com > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders > > _______________________________________________ > Flashcoders mailing list > Flashcoders@chattyfig.figleaf.com > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders > > > _______________________________________________ Flashcoders mailing list Flashcoders@chattyfig.figleaf.com http://chattyfig.figleaf.com/mailman/listinfo/flashcoders _______________________________________________ Flashcoders mailing list Flashcoders@chattyfig.figleaf.com http://chattyfig.figleaf.com/mailman/listinfo/flashcoders