s2compiled2

s2compiled2 — Clustered. Stores user (not system) S2 layers, and is lazily migrated. This table is indexed by userid, layerid, and contains data that is compressed when it's put in. (Tests show this reduces data size by about 75 percent.) New saves go here. Loads try this table first (unless user is system) and if miss, then try the s2compiled table on the global.

s2compiled2

Column name Type Null Default Description
userid int unsigned   0  
s2lid int unsigned   0  
comptime int unsigned   0  
compdata mediumblob YES Gzipped compiled layer data.
Key name Type Column(s)
PRIMARY PRIMARY