Changeset 852 for trunk/Modules/NetworkConfigLinux/Generators/Latency.php

Timestamp:

Oct 25, 2017, 10:55:05 PM (7 years ago)

Author:

chronos

Message:

• Modified: Use better transaction mechanism for netwatch import and latency measurement.
• Fixed: Query duration mesurement using outdated microtime result.

File:

• trunk/Modules/NetworkConfigLinux/Generators/Latency.php (modified) (1 diff)

trunk/Modules/NetworkConfigLinux/Generators/Latency.php

@@ -22 +22 @@
     exec('fping -e -r '.$RetryLimit.' -t '.$Timeout.' -a '.implode(' ', $Hosts).' 2>/dev/null', $Output);
 
-    $this->Database->query('BEGIN');
-    foreach($Output as $Index => $Line) {
+    $Queries = array();
+    foreach($Output as $Index => $Line) 
+    {
       $IP = substr($Line, 0, strPos($Line, ' '));
       $Line = substr($Line, strpos($Line, '(') + 1);
       $Value = substr($Line, 0, strpos($Line, ' '));
       //echo($IP.' '.$Value."\n");
-      $this->Database->insert('NetworkInterfaceLatency', array('Interface' => $HostInterface[$IP],
+      $Queries[] = $this->Database->GetInsert('NetworkInterfaceLatency', array('Interface' => $HostInterface[$IP],
         'Value' => $Value, 'Time' => TimeToMysqlDateTime($Time)));
     }
-    $this->Database->query('COMMIT');
+    $this->Database->Transaction($Queries);
   }