MySQL table question
#1

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 ?!
Reply
#2

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.
Reply
#3

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?
Reply
#4

............bump
Reply
#5

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


Forum Jump:


Users browsing this thread: 1 Guest(s)