Msql vs File saving
#1

I'm planning on making a mysql gm, But i have a doubt, Wich one is better , Mysql or file saving (.ini) , I know ofcourse mysql is faster and more functional but I CANT HAVE mysql and my servers files on the same pc coz i cant buy a dedicated server and will be needed to use 000webhost for it (or is there any way to get them on same pc) So wich one shall i make?
Reply
#2

For me, absolutely MYSQL!

More functions, faster, better!
Reply
#3

Read the post again
Reply
#4

The posibility is to rent a VPS(arround 10 -20 dollars), with for example Ubuntu, here you can run your SA-MP server, MySQL Server and an Apache server.

Also if you want to host it home, you can use xampp to setup an apache and MySQL Server

Hope it helped you a bit
Reply
#5

Quote:
Originally Posted by Swiftz
Посмотреть сообщение
I'm planning on making a mysql gm, But i have a doubt, Wich one is better , Mysql or file saving (.ini) , I know ofcourse mysql is faster and more functional but I CANT HAVE mysql and my servers files on the same pc coz i cant buy a dedicated server and will be needed to use 000webhost for it (or is there any way to get them on same pc) So wich one shall i make?
mysql is not faster... its slover, it cant be faster than fwrite(fastest way for saving .ini, actually all ini systems use fwrite), but it have some great things that fwrite dont have. Good thing is lets say you want to unban players account, with fwrite you must load all file, change only banned key, and again save whole file, but with mysql u can just update one key, and dont need to load other data and save other data like with fwrite...

definitely mysql use!
Reply
#6

I suggest you to buy VPS and make mysql one.
If you can't, don't make it mysql it will be 100000 times slower than files and people would be waiting up to 5-10 seconds to login.
Only way mysql is faster than files is when its on localhost, otherwise mysql is shit.
Reply
#7

I find MySQL better.

Because you can connect an account database from an website with the account database from the server.
So lets say, you create an account on the server, you can log in with it on the site...

You can host a MySQL database on your pc by installing WAMP or XAMPP.
Or you can host it for free on websites like http://www.freemysql.net or http://www.db3free.net
Reply
#8

Do not use an external database for your sa-mp server unless you want to experience some extreme lag.
Reply
#9

Quote:
Originally Posted by Ivan_Pantovic
Посмотреть сообщение
I suggest you to buy VPS and make mysql one.
If you can't, don't make it mysql it will be 100000 times slower than files and people would be waiting up to 5-10 seconds to login.
Only way mysql is faster than files is when its on localhost, otherwise mysql is shit.
mysql is not faster on localhost, i tested, its slover...

you have point with VPS, but some samp hosts give and mysql database option, so it is working on localhost, only i dont know quaility of their machines... remote connection from one machine where is samp server to another where is mysql is not good, and it will work very slow...
Reply
#10

It's 'slower' not 'slover' and as ****** already wrote, the SQLite is more then enough for SA-MP.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)