[x96664]

Well, I'm pretty sure that I'm not the first person who asks about that, but what are the benefits and disadvantages of MySQL compared to SQLite ?

[-Prodigy-]

Pretty much everything mentioned here: http://stackoverflow.com/questions/3630/sqlite-vs-mysql

[Mattakil]

mysql allows you to integrate your server with your website, via a user cp. sqlite is faster, and does not require a mysql server to run, so you can work on it without an internet connection, and if your sql server is different from your samp, and the sql goes down, your server wont work right

[CJay9209]

mattakil is mostly right - u can run a website off SQLite no problem however. I run 3 for clients that use SQLite and have no issues. SQLite however does not support multi-threading.

HOWEVER to the best of my knowledge (which is likely out of date) none of the MySQL plugins for samp are capable of that yet - and even then it needs to be threaded at the script level which i think in pwn is not really possible due to it's rather linear nature.

I will stress I may be wrong in this, but in my view, unless you have a mysql thats guaranteed to be up and running 24/7 theres no real reason to use it over sqlite other than if you were to thread it for speed. It's just not necessary to run MySQL full for such a mundane task as storing data for an sa-mp server.