a lot of tables in mysql - 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)
+--- Thread: a lot of tables in mysql (/showthread.php?tid=632270)

---

a lot of tables in mysql - Bussyman - 11.04.2017

Hi,

What mysql search faster, for ex i have 5 mil tables, like

table_1, table_2 .... table_5000000

If i do query SELECT * FROM table_%d it's will be faster than if i create one table table and there make 5000000 insert and do

SELECT * FROM table

---

Re: a lot of tables in mysql - Vince - 11.04.2017

There is really no reason to create a gazillion tables for a simple SA-MP server. A MySQL server can handle 5 millions rows quite confidently, provided that you have proper indexing. That means using the primary key. Full-text searches will be slow as hell.

A single table can store 64 terabytes of data; at least a billion records. You would probably need a few MySQL servers working in liaison to get any reasonable performance out of this but it's theoretically possible.

---