Only transfer data that's being used, to reduce loading and speed things up.

perlDreamer · perlDreamer · commit c120a8b28dcb · 2012-07-20T10:52:56.000-07:00
diff --git a/sbin/findBrokenAssets.pl b/sbin/findBrokenAssets.pl
@@ -72,7 +72,7 @@ sub progress {
 
 # Order by lineage to put corrupt parents before corrupt children
 # Join assetData to get all asset and assetData
-my $iterator_sql   = "SELECT * FROM asset LEFT JOIN assetData USING ( assetId ) ";
+my $iterator_sql   = "SELECT assetId, className, revisionDate, parentId FROM asset LEFT JOIN assetData USING ( assetId ) ";
 my $sql_args = [];
 if ($op_assetId) {
     my $asset_selector    = 'where assetId = ? ';
