Msql vs File saving - Printable Version

Msql vs File saving - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Msql vs File saving (/showthread.php?tid=264502)

Msql vs File saving - Swiftz - 26.06.2011

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?

Re: Msql vs File saving - tbedy - 26.06.2011

For me, absolutely MYSQL!

More functions, faster, better!

Re: Msql vs File saving - Swiftz - 26.06.2011

Read the post again

Re: Msql vs File saving - Kastranova - 26.06.2011

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

Re: Msql vs File saving - zerocoolos - 26.06.2011

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!

Re: Msql vs File saving - Ivan_Pantovic - 26.06.2011

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.

Re: Msql vs File saving - svorpyx - 26.06.2011

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

Re: Msql vs File saving - Vince - 26.06.2011

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

Re: Msql vs File saving - zerocoolos - 26.06.2011

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...

Re: Msql vs File saving - Omega-300 - 26.06.2011

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