[Bussyman]

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

[Vince]

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.