Stan Hoeppner: [ Charset ISO-8859-1 unsupported, converting... ] > Wietse Venema put forth on 11/24/2010 6:18 AM: > > > That's 0.5 seconds to read the table once, and milliseconds to query it. > > Is it? I must be misreading this then. But it sure looks like each > query is taking over half a second. > > Table has 67669 CIDRs: > > [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:dnswl > > real 0m0.618s > user 0m0.464s > sys 0m0.064s
You measure the TIME TO COMPILE PLUS TIME TO QUERY. That is not at all representative for how Postfix daemon processes use the table. To SEPARATE the ONE-TIME COMPILE cost from the INCREMENTAL QUERY cost, time postmap -q 1.2.3.4 cidr:dnswl time postmap -q - cidr:dnswl < A-VERY-LARGE-FILE and deduct one from the other. Wietse