[bind10-dev] Enum types, was Adding another index to the records SQLite3 table

[Shane Kerr]

Jinmei,

On Friday, 2012-09-28 01:10:54 -0700, 
JINMEI Tatuya / 神明達哉 <jinmei at isc.org> wrote:
> 
> Also, not directly related to this, but I'm about to propose changing
> the data type for the RR types from text to integer to improve normal
> lookup performance.  I'm not sure if it really helps, but I wonder
> whether it might be possible indices on integers are cheaper than
> those on texts.  If so, we may first try to make this level of schema
> change and see how indices on them work.

Both PostgreSQL and MySQL have an ENUM type, so at least in those cases
we can get the benefits of both text for readability and integers for
speed (I think). SQLite is too "lite" for this, of course....

--
Shane