To store Client Hints data, two new tables were added. Now that data collection is enabled on enwiki, the amount of rows in the cu_useragent_clienthints_map table has reached around 4 million. Once data deletion starts in 3 months time, there will be around 48 million rows.
This task has two objectives:
- Do the DBAs think this many rows will cause issues for display and/or continued collection
- Whether any optimisations can be made to reduce the row count
On the second point some thoughts have been discussed, but mostly this cannot be done until T344800 is completed. Ideas so far are:
- Only store uach_name of brands when the same name isn't being used for rows with uach_name as fullVersionList
- Don't store data that has little entropy and therefore isn't displayed
Some discussion about adding an extra column cu_useragent_clienthints to store the version number instead of combining it with a space was had, but this is likely not going to be done for the MVP.