[bind10-dev] some suggested topics for the team call

[Michal 'vorner' Vaner]

Hello

Two small comments in case I forget during the call:

On Tue, Oct 02, 2012 at 12:29:57AM -0700, JINMEI Tatuya / 神明達哉 wrote:
> - PostgreSQL vs MySQL
>   People talk about PostgreSQL backend for BIND 10 recently, but from
>   my quick experiments, it has some missing feature in C API
>   (https://lists.isc.org/pipermail/bind10-dev/2012-October/003868.html)
>   and (at least in very limited benchmark scenarios) generally slower
>   than MySQL (see, eg.
>   https://lists.isc.org/pipermail/bind10-dev/2012-October/003866.html)
>   MySQL also supports query cache while PostgreSQL doesn't.  Depending
>   on query usage it's another advantage of MySQL.  I have no
>   personal reason for pushing MySQL, but experimental facts so far
>   seem to indicate MySQL is probably the better choice for our next
>   target.

MySQL uses table engines that don't support transactions by default. That's the
main reason mysql is faster in many situations. What engine did you measure
against? Because I think we do need transactions (or at least we want to make
sure the admin can choose to enable them).

> - How to improve query performance with DB backend
>   https://lists.isc.org/pipermail/bind10-dev/2012-October/003866.html
>   It involves substantial schema changes.  The timing of supporting
>   another backend is probably a good opportunity to do this type of
>   change.

This might be related ‒ we didn't really talk much about if we want to include
the index for faster iteration or if we want to solve the problem differently
(sorting by name only, for example).

With regards

-- 
When all else fails, EAT!!!

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/20121002/9943a02e/attachment.bin>