MantisBT - v1.1 Release (Closed)
View Issue Details
0000071v1.1 Release (Closed)[All Projects] Generalpublic2008-10-06 21:072009-09-09 22:42
Assigned Tocaseydk 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version1.1 
Summary0000071: Cache Total Task Counts
When you have a lot of projects with lots of tasks, the Project List screen can take a ridiculous amount of time to render (3 min w/ 400 projects of 100 tasks each). Caching the total tasks in advance - updated at task creation/deletion - would decrease this load significantly.
TagsNo tags attached.
related to 0000169closed caseydk v1.1 Release (Closed) Cache Time Worked 
child of 0000142closed caseydk Pending Requests System Performance Improvements 
Attached Files

2009-08-30 20:43   
Resolved in r594.

Whenever a task is saved (via store or delete), the current task count is calculated and stored on the projects table, the old method using the "task_total" temp-table is still in place for backwards compatibility reasons.
2009-09-09 22:42   
Closed for release.

Issue History
2008-10-06 21:07caseydkNew Issue
2009-04-27 22:01caseydkRelationship addedchild of 0000142
2009-05-31 21:23caseydkRelationship addedrelated to 0000169
2009-08-13 06:54caseydkStatusnew => assigned
2009-08-13 06:54caseydkAssigned To => caseydk
2009-08-13 06:54caseydkProjectPending Requests => v1.1 Release (Closed)
2009-08-30 20:43caseydkStatusassigned => resolved
2009-08-30 20:43caseydkResolutionopen => fixed
2009-08-30 20:43caseydkNote Added: 0000403
2009-09-09 22:42caseydkStatusresolved => closed
2009-09-09 22:42caseydkNote Added: 0000456
2009-09-09 22:42caseydkFixed in Version => 1.1