DB Optimization - Events Table
This table handles event "event" that occurs in a match. Warzone matches easily have over 300 for reference. This table is growing fast and fast and not the best optimized.
Things I see
int11for seconds_since_start is dumb. We probably can get away with a smaller number of probably like 4 digits, so mediumint.
DECIMAL(12,8)is overkill for points. Lets do
- The ID columns are locked to
INT10since they are in foreign key with account table.
- 32 chars for stock_id/weapon_id. Overkill. Probably can be whatever max is 12 or 16.
- Distance is
DECIMAL(8,2). Not needed. Probably another
- I don't know enough about
utf8_unicide_ci, but seeing how they are IDs and UUIDs we can see if we can leverage a different charset. Research needed.