MantisBT: master afacf2ec

Diff Back to Repository
Author Committer Branch Timestamp Parent
vboctor vboctor master 2015-01-13 21:36 master 5e5e5750
Affected Issues  0017966: My View Page takes about 5s to load
Changeset

Don't process history entries outside date range

Don't process history entries outside date range

The following queries cut the number of queries in half:

  • Remove skip() method from events class since history api does the filtering.
  • When processing history events for an issue, only process ones within desired time range.

Before:

  • Total queries executed: 1232
  • Unique queries executed: 1231
  • Total query execution time: 0.7097 seconds

After:

  • Total queries executed: 574
  • Unique queries executed: 573
  • Total query execution time: 0.2581 seconds

Issue 0017966
mod - core/classes/IssueAssignedTimelineEvent.class.php Diff File
mod - core/classes/IssueNoteCreatedTimelineEvent.class.php Diff File
mod - core/classes/TimelineEvent.class.php Diff File
mod - core/history_api.php Diff File
mod - core/timeline_api.php Diff File
mod - core/timeline_inc.php Diff File