From 2d802ebc16003e27fe86295ccd6b7c47996c7314 Mon Sep 17 00:00:00 2001 From: Frédéric Buclin Date: Sat, 28 Sep 2013 00:59:33 +0200 Subject: Bug 340160: Speed up LogActivityEntry() r=dkl a=justdave --- Bugzilla/Bug.pm | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'Bugzilla/Bug.pm') diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm index 4d2421a59..3000bd0ae 100644 --- a/Bugzilla/Bug.pm +++ b/Bugzilla/Bug.pm @@ -3953,7 +3953,11 @@ sub get_activity { # Update the bugs_activity table to reflect changes made in bugs. sub LogActivityEntry { my ($i, $col, $removed, $added, $whoid, $timestamp, $comment_id) = @_; - my $dbh = Bugzilla->dbh; + state $sth = + Bugzilla->dbh->prepare('INSERT INTO bugs_activity + (bug_id, who, bug_when, fieldid, removed, added, comment_id) + VALUES (?, ?, ?, ?, ?, ?, ?)'); + # in the case of CCs, deps, and keywords, there's a possibility that someone # might try to add or remove a lot of them at once, which might take more # space than the activity table allows. We'll solve this by splitting it @@ -3977,10 +3981,7 @@ sub LogActivityEntry { trick_taint($addstr); trick_taint($removestr); my $fieldid = get_field_id($col); - $dbh->do("INSERT INTO bugs_activity - (bug_id, who, bug_when, fieldid, removed, added, comment_id) - VALUES (?, ?, ?, ?, ?, ?, ?)", - undef, ($i, $whoid, $timestamp, $fieldid, $removestr, $addstr, $comment_id)); + $sth->execute($i, $whoid, $timestamp, $fieldid, $removestr, $addstr, $comment_id); } } -- cgit v1.2.3-24-g4f1b