For pagination usecases where the SQL API is used currently. Also for missions, where the display icon is the first mission task's icon (currently all tasks are queried and transferred, making this inefficient). For missions, an alternative that might be preferable is adding a new column for the display icon, as this fits the data shape better and allows skipping mission task queries entirely.
For pagination usecases where the SQL API is used currently. Also for missions, where the display icon is the first mission task's icon (currently all tasks are queried and transferred, making this inefficient). For missions, an alternative that might be preferable is adding a new column for the display icon, as this fits the data shape better and allows skipping mission task queries entirely.