Changeset 863 for trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

Timestamp:

Oct 4, 2019, 8:00:01 PM (5 years ago)

Author:

chronos

Message:

• Fixed: Optimized speed of interface up-down records duration update.

File:

• trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php (modified) (1 diff)

trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

@@ -69 +69 @@
 
     // Update Duration for new items
-    $this->Database->query('UPDATE NetworkInterfaceUpDown AS T1, NetworkInterfaceUpDown AS T2 SET T1.Duration = TIMESTAMPDIFF(SECOND, T1.Time, T2.Time) WHERE (T2.Previous = T1.Id) AND (T2.Interface = T1.Interface) AND (T1.Duration IS NULL)');
+    echo("Update Duration\n");
+    $this->Database->query('UPDATE NetworkInterfaceUpDown AS T1, NetworkInterfaceUpDown AS T2 '.
+      'SET T1.Duration = TIMESTAMPDIFF(SECOND, T1.Time, T2.Time) '.
+      'WHERE (T2.Previous = T1.Id) AND (T2.Interface = T1.Interface) AND (T1.Duration IS NULL) AND (T2.Time = "'.TimeToMysqlDateTime($StartTime).'")');
+    echo("done\n");
 
     // Set offline all interfaces which were not updated as online