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

[Michal 'vorner' Vaner]

Hello

On Fri, Mar 02, 2012 at 03:51:37PM -0800, JINMEI Tatuya / 神明達哉 wrote:
> Is my understanding correct?  If so, is there any easy way (easy = by
> not fundamentally changing the table organization) to get the result
> we want to get more efficiently?  What we need to know is basically
> that when we know there is no row whose name is
> "nxdomain.example.com." whethere there is a row whose name is a pure
> subdomain of it (e.g. "a.nxdomain.example.com.").

That is to find if the nxdomain.example.com is empty nonterminal, right? I have
an idea for a hack, but I don't know if anyone would like it.

Simply create a nonexistent RTYPE, let's call it EMPTY_NONTERMINAL and make sure
the data does contain an entry for each such empty non-terminal. If we assumed
the sqlite3 database is „captive“ (user's are not allowed/expected to modify it
manually), then it could be done.

With regards.

-- 
In the name of kernel, compiler and holy penguin

Michal 'vorner' Vaner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <https://lists.isc.org/pipermail/bind10-dev/attachments/20120303/1ffe9510/attachment.bin>