SA-MP Forums Archive
MySQL table question - 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: MySQL table question (/showthread.php?tid=176979)



MySQL table question - Ribber - 15.09.2010

I have around 200 variables and strings which will be saved & loaded in players file.
And I like to save & load players file now in MySQL and not in the scriptfiles/Players folder, because it's to hard to manage the files and change them (maybe I have 20k registered players, it loads maybe 30 seconds until I can change & save a file)
Now what do you advise to me, create around 200 tables or is there another solution ?!


Re: MySQL table question - Vince - 15.09.2010

Hahaha, you want to create a table for each variable? Put them all in one, or maybe two tables.
The whole point of MySQL is the table structure. Each registered player will have his own row (containing the 200 vars) in the table.


AW: MySQL table question - Ribber - 15.09.2010

rofl, I mean field not table .. xD
yeah, so is this good when I have in one table (player table) 200 fields ? isn't that bad?


AW: MySQL table question - Ribber - 15.09.2010

............bump


Re: MySQL table question - Johndaonee - 15.09.2010

I don't think there will be any problems if its on localhost(Wont matter i suppose, just faster when its local), I mean.. MySQL is much better than using files, so better switch to it I am using it, and its much easier, and faster imo.