Changeset 26294 for trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

Timestamp:

Nov 30, 2009, 4:56:31 PM (16 years ago)

Author:

watersc1

Message:

Updated the topfew_count to be 15 (from 3. 15 is roughly a quarter of the cluster).

Reworked the replication volume selection SQL to run in a reasonable timescale.

File:

• trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (1 diff)

trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

@@ -310 +310 @@
                    JOIN volume 
                    ON instance.vol_id = volume.vol_id
+                   WHERE so_id = (
+                                  SELECT so_id
+                                  FROM storage_object
+                                  WHERE ext_id = ?
+                                 )
                   ) AS i
             ON m.vol_id = i.vol_id
-            AND i.so_id = (
-                SELECT so_id
-                FROM storage_object
-                WHERE ext_id = ?
-            )
          WHERE
              i.vol_id IS NULL