[Mamal75]

Hello everyone
I have some questions about mysql user system
1.for a big server (+100 player for example) which user system is better ? Y_ini or mysql ?
Please tell your reason too.
2.which one is faster ? Y_ini or mysql ?
3.is it possible that mysql lose a player data ?
For example i leave the server and system won't save my stats
4.can i make mysql database and phpmyadmin on my linux vps ? And can i make it on windows too?
Thanks in advance

[BroZeus]

1. MySQL
2. MySQL
3. Yep everything is possible but the possibility is far more less than losing data in ini based data base..
4. Yes

[Jay_]

Data storage (in particular, ini vs database) is a large subject that many developers have debates over every day.

It depends on how you're going to be using your data and how much you're going to store and manage.

If you're planning on reading your data from a third party source, for example if you're planning on creating some kind of external website interface for user accounts then MySQL is an excellent heterogeneous standalone relational database engine that would be ideal for this.

However, if your data is going to be limited in size and only typically required locally, then perhaps an ini system or indeed local database engine such as SQLite (which is natively supported by SA-MP) would be better.

In terms of question 3: Quite a broad question, but yes it can loose data if it's not used properly. As can any other means of storage.

[Mamal75]

Thanks a lot brozeus and mr jay_
If i want to save fo example 50 stats items is it possible ?
And how many items can i save with mysql ?
In maximum ?

[Jay_]

There are no limits on how much data you wish to store (well, providing you have enough memory but that doesn't tend to be an issue these days).

I suggest you do some research on ****** around this subject - it's a huge, huge subject.

[Mamal75]

I can't give rep
But thanks for helping
I'll search it
Thanks