[bind10-dev] scalability issue with SQL(ite3) select with 'like'

[Stephen Morris]

On 05/03/12 19:10, JINMEI Tatuya / 神明達哉 wrote:
> Good question, and I don't know the answer:-) I've actually wondered
> whether it may make sense to use numeric representation for RR types
> and classes for several reasons including the search performance and
> eliminating ambiguities (such as TYPE1 and A).  I guess one reason for
> the choice of text (although may not be very intentional) was for
> readability for humans, especially when we allow admins to modify the
> database by hand, not via the BIND10 APIs.

I suggest that we go for integer values.

To help admins who wish to query the database directly, we can add a 
couple of pre-filled tables to translate between numeric values and 
RRtype/RRclass.  If someone is using SQL to query the database, they 
should be able to join the tables to produce more meaningful output.

(Alternatively, we could supply a suitable view that did the join for them.)

Stephen