Changeset 32 for trunk/dnsbl/dnsbl.cgi

Timestamp:

03/25/11 17:16:38 (13 years ago)

Author:

Kris Deugau

Message:

/trunk/dnsbl

Changeset to improve export speed on DNSBL database. By keeping
IP counts for each block, and directly tracking the parent of
each block and IP, an export taking ~90 seconds can be brought
down under 20.

• updated initial tabledef SQL
• Add addparents.sql SQL tabeldef and setparents.pl data update script
• Tweak reporting of IP since it now requires the parent block(s) so the parent field can be filled in

Also add delist-ip script and Makefile

File:

• trunk/dnsbl/dnsbl.cgi (modified) (2 diffs)

trunk/dnsbl/dnsbl.cgi

@@ -96 +96 @@
 
   my $err = '';
-  my $count = $dnsbl->report($webvar{ip});
   my $org0id = $dnsbl->orgexists($webvar{org0});
   if (!$org0id) {
@@ -132 +131 @@
     }
   }
+  my $count = $dnsbl->report($webvar{ip});
 
   $page->param(ip => $webvar{ip});