Only transfer data that's being used, to reduce loading and speed thi…

…ngs up.
plainblack · Jul 20, 2012 · c120a8b · c120a8b
1 parent 7c03fc7
commit c120a8b
Showing 1 changed file with 1 addition and 1 deletion.
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 = ? ';