25.06.2017, 17:29
Well recently i started a little bit complicated modular GM, and i had few ideas so i checked out that Easy SQL includes (there are 2-3 of them and at least one is only for SQLite).
But i must say i just dont see a reason for using them in the first place.
Benefit is that you get simple functions to interact with few columns. Set admin level, player money, etc...That's nice. But downside is that we need to learn that functions.
Then another downside is that there is no more complicated interactions with database like joining tables.
And select queries are not threaded, so that is a HUGE downside if you want to write lag free server. I wont argue, time that takes to send select query and return the results is blazing fast, but its still a time that server has to wait for results. Any lag spike between mysql and samp server will result in a lag on samp server.
But i must say i just dont see a reason for using them in the first place.
Benefit is that you get simple functions to interact with few columns. Set admin level, player money, etc...That's nice. But downside is that we need to learn that functions.
Then another downside is that there is no more complicated interactions with database like joining tables.
And select queries are not threaded, so that is a HUGE downside if you want to write lag free server. I wont argue, time that takes to send select query and return the results is blazing fast, but its still a time that server has to wait for results. Any lag spike between mysql and samp server will result in a lag on samp server.