[bind10-dev] large host qps using sqlite3

[Jeremy C. Reed]

(I was curious about #2610.) I re-enabled my benchmark scripts to 
include the sqlite3 results for a largehost scenario again.

Here are some results for me using 100,000 zones at 15 small (normal?) 
records each. (So not a single large zone.) The zone.sqlite3 for all the 
following was generated using bind10-1.0.0-beta's b10-loadzone. (Took 
about 18 hours to load.)

bind10-20120927-release largehost-sqlite3-cpus4.nxdomain 8.583526 qps
bind10-20120927-release largehost-sqlite3-cpus4.soa 9903.827860 qps
bind10-20120927-release largehost-sqlite3-cpus4.success 10376.077003 qps
bind10-20120927-release largehost-sqlite3-.nxdomain 0.324478 qps  **** bad ****
bind10-20120927-release largehost-sqlite3-.soa 2421.272730 qps
bind10-20120927-release largehost-sqlite3-.success 2505.405217 qps

bind10-20121115-release largehost-sqlite3-cpus4.nxdomain 12470.900510 qps
bind10-20121115-release largehost-sqlite3-cpus4.soa 10081.519433 qps
bind10-20121115-release largehost-sqlite3-cpus4.success 10330.754603 qps
bind10-20121115-release largehost-sqlite3-.nxdomain 3313.536920 qps
bind10-20121115-release largehost-sqlite3-.soa 2520.836574 qps
bind10-20121115-release largehost-sqlite3-.success 2645.103554 qps

bind10-1.0.0-beta-release largehost-sqlite3-cpus4.nxdomain 12423.870508 qps
bind10-1.0.0-beta-release largehost-sqlite3-cpus4.soa 10011.212601 qps
bind10-1.0.0-beta-release largehost-sqlite3-cpus4.success 10264.209219 qps
bind10-1.0.0-beta-release largehost-sqlite3-.nxdomain 3320.076778 qps
bind10-1.0.0-beta-release largehost-sqlite3-.soa 2509.086750 qps
bind10-1.0.0-beta-release largehost-sqlite3-.success 2599.534638 qps

master/20130108144918 largehost-sqlite3-cpus4.nxdomain 12594.559775 qps
master/20130108144918 largehost-sqlite3-cpus4.soa 10034.445305 qps
master/20130108144918 largehost-sqlite3-cpus4.success 10367.619193 qps
master/20130108144918 largehost-sqlite3-.nxdomain 3152.873908 qps
master/20130108144918 largehost-sqlite3-.soa 2416.531236 qps
master/20130108144918 largehost-sqlite3-.success 2483.132746 qps

The graphs at http://git.bind10.isc.org/~jreed/bench/releases/ are 
updated. Also see 
http://bind10.isc.org/wiki/DnsBenchmarks#Authoritativeserverfor100000zoneswith0delegationsand15records  
for details.

(I see the qps performance for a single small zone using sqlite3 is 
slower than this. That does not make sense to me. Or maybe the sqlite3 
zone database changed between versions and I am using a better one for 
the largehost tests. It is much too slow for me to regenerate it for 
each release using its release loadzone, but I guess I should.)