20.05.2015, 20:38
I don't think a samp server has the ability to send more queries to mysql than mysql can handle.
Even big MMORPG servers such as World of Warcraft (which runs more than 3000 players per server), ******, ******** etc, they all use mysql.
To choke mysql, you'll have to get a much bigger server than samp, sending 100.000 queries every second or even more.
Mysql can even handle queries that return a result set of 4 Gigabytes of data (that would be a table with 1.000.000 rows and dozens of fields, using a query such as "SELECT * FROM MyHugeTable".
It can even store pictures, music files and probably movies as well in a table.
Use little queries all over the place and you'll be fine.
You won't be able to crash mysql using a little samp server with only 50 players.
Even big MMORPG servers such as World of Warcraft (which runs more than 3000 players per server), ******, ******** etc, they all use mysql.
To choke mysql, you'll have to get a much bigger server than samp, sending 100.000 queries every second or even more.
Mysql can even handle queries that return a result set of 4 Gigabytes of data (that would be a table with 1.000.000 rows and dozens of fields, using a query such as "SELECT * FROM MyHugeTable".
It can even store pictures, music files and probably movies as well in a table.
Use little queries all over the place and you'll be fine.
You won't be able to crash mysql using a little samp server with only 50 players.