[Bio] / Sprout / ERDB.pm Repository:
ViewVC logotype

Diff of /Sprout/ERDB.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.24, Wed Oct 12 02:56:04 2005 UTC revision 1.26, Tue Oct 18 06:47:46 2005 UTC
# Line 877  Line 877 
877      my $dbh = $self->{_dbh};      my $dbh = $self->{_dbh};
878      my $command = "SELECT DISTINCT " . join('.*, ', @{$objectNames}) . ".* FROM " .      my $command = "SELECT DISTINCT " . join('.*, ', @{$objectNames}) . ".* FROM " .
879                  join(', ', @{$objectNames});                  join(', ', @{$objectNames});
880        Trace("SQL = $command") if T(SQL => 4);
881      # Check for a filter clause.      # Check for a filter clause.
882      if ($filterClause) {      if ($filterClause) {
883          # Here we have one, so we convert its field names and add it to the query. First,          # Here we have one, so we convert its field names and add it to the query. First,
# Line 1308  Line 1309 
1309      Trace("Loading table $relationName from $fileName") if T(2);      Trace("Loading table $relationName from $fileName") if T(2);
1310      # Get the database handle.      # Get the database handle.
1311      my $dbh = $self->{_dbh};      my $dbh = $self->{_dbh};
     # Start a transaction.  
     $dbh->begin_tran;  
1312      # Get the input file size.      # Get the input file size.
1313      my $fileSize = -s $fileName;      my $fileSize = -s $fileName;
1314      # Get the relation data.      # Get the relation data.
# Line 1359  Line 1358 
1358              }              }
1359          }          }
1360      }      }
     # Commit the database changes.  
     $dbh->commit_tran;  
1361      # Analyze the table to improve performance.      # Analyze the table to improve performance.
1362      $dbh->vacuum_it($relationName);      $dbh->vacuum_it($relationName);
1363      # Return the statistics.      # Return the statistics.

Legend:
Removed from v.1.24  
changed lines
  Added in v.1.26

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3