21.08.2016, 11:01
Do not give random bs to people if you don't understand anything.
1GB data is way way way more than 500 accounts, my 50 or something tables + 10 data in each file dump is 38kb for comparison.
http://dev.mysql.com/doc/refman/5.7/...uirements.html
About saving 30 cars in 1 field, you should never do that, but rather use a proper db structure.
https://sampforum.blast.hk/showthread.php?tid=609888
https://sampforum.blast.hk/showthread.php?tid=420363
https://sampforum.blast.hk/showthread.php?tid=505081
Here are 3 tutorials by Vince on how to normalize your database.
You can create a table for their cars, their items their weapons and w/e, if they are only part of 1 faction you can add a field in main table, if not, create a seprate table.
Then associate tables to each other accordingly.
1GB data is way way way more than 500 accounts, my 50 or something tables + 10 data in each file dump is 38kb for comparison.
http://dev.mysql.com/doc/refman/5.7/...uirements.html
About saving 30 cars in 1 field, you should never do that, but rather use a proper db structure.
https://sampforum.blast.hk/showthread.php?tid=609888
https://sampforum.blast.hk/showthread.php?tid=420363
https://sampforum.blast.hk/showthread.php?tid=505081
Here are 3 tutorials by Vince on how to normalize your database.
You can create a table for their cars, their items their weapons and w/e, if they are only part of 1 faction you can add a field in main table, if not, create a seprate table.
Then associate tables to each other accordingly.