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

[Michal 'vorner' Vaner]

Hello

On Mon, Mar 05, 2012 at 10:52:45AM -0800, JINMEI Tatuya / 神明達哉 wrote:
> > Well, this is used to make sure RRs are aggregated to RRsets correctly, they
> > need to be consecutive. I think we don't need anything else than that single
> > RRset „sticks together“ in the output of the query and we probably could do it
> > in a different way. But I don't have a quick idea how.
> 
> Hmm, okay.  Realistically, (if I understand it correctly) we're
> currently using the iterator result only for xfrout, in which case we
> don't even need the concept of "RRset".  We might want to use it for
> dumping a zone content into a textual zone file in future, but it also
> doesn't require the RRset concept, although it would be less readable
> if RRs of the same same RRset are not listed as a group.  So I guess
> we could make a compromise here in practice.

And for populating in-memory in future. But it could be able to handle that as
well.

Using numerical values sounds like a nice option for some databases ‒ I think we
want the sqlite3 to be human readable a little bit (that one is not expected to
perform well anyway), so I'd keep it textual for now.

With regards

-- 
If you are over 80 years old and accompanied by your parents, we will
cash your check.

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/20120306/5e7f202b/attachment.bin>