11.04.2017, 19:04
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.
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.