Project

General

Profile

Bug #17284

Spreadsheet report page choked on large Campaigns

Added by Marc Mengel about 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
07/27/2017
Due date:
% Done:

100%

Estimated time:
First Occurred:
Scope:
Internal
Experiment:
-
Stakeholders:
Duration:

Description

Trying the spreadsheet report on Campaigns with ~50k jobs per day was eating lots of memory and timing out, 'cause we were reading all the jobs in from the database and counting them.

Associated revisions

Revision d965f72c (diff)
Added by Marc Mengel about 3 years ago

changes for issue #17284

History

#1 Updated by Marc Mengel about 3 years ago

Recoding now to make the database do the counting; behaves much better, but still not quite fast enough...

#2 Updated by Marc Mengel about 3 years ago

  • % Done changed from 0 to 90

Updated campaign_sheet and campaign_task_files pages to count things in the database, and also task_min_job to push the min into the database...

#3 Updated by Anna Mazzacane about 3 years ago

  • Status changed from New to Work in progress

#4 Updated by Marc Mengel about 3 years ago

  • Status changed from Work in progress to Resolved
  • % Done changed from 90 to 100

#5 Updated by Anna Mazzacane about 3 years ago

  • Status changed from Resolved to Closed


Also available in: Atom PDF