maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Dynamic ENUM
CREATION DATE..: Thu, 30 Jun 2011, 18:13
SUPERVISOR.....: 
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-BackLog
TASK ID........: 228 (http://askmonty.org/worklog/?tid=228)
VERSION........: Server-5.7
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 200 (hours remain)
ORIG. ESTIMATE.: 200

PROGRESS NOTES:



DESCRIPTION:

Create a ENUM-type like data type that does string compression (at a scale). For
example, create a type LOOKUP(255) CHARSET utf8. We store browser user-agent
strings here, you store bigint unsigned numbers internally, and create a lookup
structure so that each occurrence of a string is physically stored only once.
Convert from VARCHAR to LOOKUP using ALTER TABLE.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)