[Plugin] Using MySQL R41-4

[Bakr]

I'm not so sure about 2...?

I'm pretty sure MySQL can easily handle thousands of UPDATE queries per second on a server that's running 2 core CPU :)

This is true. But why over utilize something when it's not necessary?

So, I recommend using MySQL over file-based systems for all of the user data and updating them the same moment they change.



MySQL has A LOT of useful features too, like event scheduler, triggers, views,...tl;dr: SQL is much bigger and much more complex language than Pawn so you'll be amazed what you can do without even having any performance impacts on the samp server itself.



For example, let's say you need to look for all of the items owned by offline player - John. That'd be a simple 1-line SELECT query and without any effort you'd have ALL of the data you need whereas INI'd take a lot of effort just to open every file (because the player is offline) and match it up using Pawn VM (like using strcmp to see if the player is item's owner) (which is much much slower than the SQL)

This goes back to point 1 - it depends on the data and how it will be used.