[PRoleplay]

Hi, I've read alot of saving method like Dini,Y_ini,SQL,SQLLite
and I wonder if what is the best method to save user account.
My Server runs at y_ini and i'm planning to switch to sql.

1.Do I need to switch to sql or stay at y_ini
2.Does SQL more effecient and faster than ini?
3. If I want to switch is it easy?


Thanks

[ThePhenix]

I would definitely switch from Y_INI to MySQL as it provides you with a vast number of possibilities that you can't get out of YINI itself.

[Rockefeller]

Sql load more faster then YSI and its more effecient , I dont know what to say about 3rd question , you need to learn sql to swich gamemode to SQL and if you have gm with alot of lines that takes time

[Gammix]

https://sampforum.blast.hk/showthread.php?tid=581453
Syntax similar to INI, easy to use, fast with good features and you don't need SQL knowledge. (advantage of switching types as well)

But in case you are willing to perform complicated stuff, then do learn SQL and use the plugins instead.

[PRoleplay]

i have background on sql
but my problem is how to switch on sql
what plugins do i need?
and is it good to switch or stay on y_ini

Edit: SQL or SQLLite?

[Dragony92]

MySQL is the best choice - https://sampforum.blast.hk/showthread.php?tid=56564
It's faster, and there are million advantages and possibilities.
And yes it will take you some time to convert it, but it's definitely worth.

[PRoleplay]

and my plan is to convert user account into sql only not the business and other .ini files

[SickAttack]

MySQL isn't the best choice. SQLite also exists.

SQLite is already in SA-MP. Check sampdb.inc.

[PRoleplay]

thanks you think is it good if user accounts will only convert to sql and the rest will stay at Y_Ini?

[Micko123]

https://sampforum.blast.hk/showthread.php?tid=590310

Check out that one.