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

[João Damas]

On 6 Mar 2012, at 14:11, Stephen Morris wrote:

> 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.

yes!

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

that would be extra nice. Don't know if sqlite is up to the task though

Joao