Yaml vs MySQL

Which do you think is better? Which is faster? Which is more efficient? I'm trying to decide between the two for a plugin I'm planning. It may have to hold quite a lot of data.

 

depends what the data is, if its just a bunch of true and false things then no i would use yml

 

no it will be numbers, player names, time stamps and such

 

how many timestamps?
numbers of what

every player that joins the server?


EDIT: why not make the user of the plugin choose? make an option to use a database

 

yes, of every player, and their name will be added more than once to different lists for different things, as for time stamps at any given point there could be well into the double digits per player and numbers could get pretty big (or small in the negatives) but only one number per player.

 

i would use a database

 

ok cheers

 

could u help me? on something?

 

I'll try?

 

http://forums.bukkit.org/threads/error-please-help.77807/

 

Use database but store everything in memory. Like on data change execute mysql query + change data un list or another structure. One of most efficient ways to store data. A lot of queries could slow down the server.

 

If you plan on keeping everything in memory there is no advantage with a database over YAML. Also a couple of hundred rows in a database is a very small amount of data, and could still be served by one YAML file. If you have a couple hundred players.