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 [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:dnswl real 0m0.518s user 0m0.424s sys 0m0.084s [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:dnswl real 0m0.514s user 0m0.448s sys 0m0.064s [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:dnswl real 0m0.514s user 0m0.452s sys 0m0.064s [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:dnswl real 0m0.695s user 0m0.448s sys 0m0.064s A much smaller table has 1517 CIDRs: [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:spammer real 0m0.030s user 0m0.024s sys 0m0.008s [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:spammer real 0m0.030s user 0m0.020s sys 0m0.008s [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:spammer real 0m0.030s user 0m0.024s sys 0m0.008s -- Stan