https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24883
--- Comment #11 from Bernardo Gonzalez Kriegel <[email protected]> --- (In reply to Jonathan Druart from comment #10) > I tried to execute all the queries in a transaction (using txn_do), but no > gain observed. With this diff in my original script diff --git a/misc/load_yaml.pl b/misc/load_yaml.pl index e670f56660..8eed5ab933 100755 --- a/misc/load_yaml.pl +++ b/misc/load_yaml.pl @@ -63,7 +63,7 @@ eval { if ($@){ die "Something went wrong loading file $file ($@)"; } - +$dbh->{'AutoCommit'} = 0; for my $table ( @{ $yaml->{'tables'} } ) { my $table_name = ( keys %$table )[0]; # table name my @rows = @{ $table->{$table_name}->{rows} }; # @@ -86,3 +86,4 @@ for my $table ( @{ $yaml->{'tables'} } ) { for my $statement ( @{ $yaml->{'sql_statements'} } ) { # extra SQL statements $dbh->do($statement); } +$dbh->{'AutoCommit'} = 1; I see changes, form ~9s to ~1.3 for marc21_framework_DEFAULT.yml for example. Of course I'm with you on putting the code in one place and other changes, just want to share my results. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
