E.g. for the mission list query, which needs to fetch different columns depending on whether the mission is an actual mission or an achievement. Right now all columns are fetched for all entries, wasting space.
A preferable alternative there might be to make a separate table for missions and achievements, as many of the concepts of missions aren't actually applicable to achievements.
E.g. for the mission list query, which needs to fetch different columns depending on whether the mission is an actual mission or an achievement. Right now all columns are fetched for all entries, wasting space.
A preferable alternative there might be to make a separate table for missions and achievements, as many of the concepts of missions aren't actually applicable to achievements.