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