Optomalize!

[nms] / web / nettkart-web.pl
diff --git a/web/nettkart-web.pl b/web/nettkart-web.pl

index 040d4767865e5ee2a5566a60ff079caf0be4933f..8f37b1efd12b63b6af21aa73879934bbee47c4c3 100755 (executable)
--- a/web/nettkart-web.pl
+++ b/web/nettkart-web.pl
@@ -6,7 +6,7 @@ use nms;
  my $cgi = CGI->new;
  
  my $dbh = nms::db_connect();
-print $cgi->header(-type=>'text/html', -refresh=>'45; http://nms.tg07.gathering.org/nettkart-web.pl');
+print $cgi->header(-type=>'text/html; charset=utf-8', -refresh=>'45; http://nms.tg07.gathering.org/nettkart-web.pl');
  
  print <<"EOF";
  <html>
@@ -17,10 +17,7 @@ print <<"EOF";
      <map name="switches">
  EOF
  
-my $q = $dbh->prepare('select * from switches natural join placements natural left join
-( select switch,sum(bytes_in)/count(*) as
-bytes_in,sum(bytes_out)/count(*) as bytes_out from get_datarate() group
-by switch ) t1');
+my $q = $dbh->prepare('select * from switches natural join placements');
  $q->execute();
  while (my $ref = $q->fetchrow_hashref()) {
         $ref->{'placement'} =~ /\((\d+),(\d+)\),\((\d+),(\d+)\)/;