[bind10-dev] performance improvements and regressions

[Michal 'vorner' Vaner]

Hello

On Tue, Feb 12, 2013 at 08:00:10PM -0800, JINMEI Tatuya / 神明達哉 wrote:
> As for the regressions, a quick run of git bisect suggested that it's
> because of the overhead introduced with #2390 and #2656 (especially
> the former).  We now use the generic lexer to convert plain text
> stored in the DB to Rdata.  While it works more accurately, it could
> be more expensive.  I don't think we have to worry about this level of
> performance regression for sqlite3 right now, but for longer term we
> can do several things to make it more efficient:

I wonder, what is the bottleneck with sqlite3, if it's CPU processing or disk
access. But I guess it would be cached for reading in the OS page cache.

Anyway, for some server-driven databases (like mysql), there'll be other
bottleneck ‒ the communication, when the data travel from bind10 to the SQL
server and back. We may overcome this by running the bind10 in enough instances,
but I wonder if it would be possible to batch the queries somehow (get all the
RRs we need at once instead of taking multiple queries, like asking for apex RRs
and the queried name at once).

With regards

-- 
BOFH Excuse #430:

Mouse has out-of-cheese-error

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/20130213/e3f347dc/attachment.bin>