MantisBT - v1.1 Release (Closed)
View Issue Details
0000071v1.1 Release (Closed)[All Projects] Generalpublic2008-10-06 21:072009-09-09 22:42
Reportercaseydk 
Assigned Tocaseydk 
PrioritynormalSeverityfeatureReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version1.1 
Summary0000071: Cache Total Task Counts
Description
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

Notes
(0000403)
caseydk   
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.
(0000456)
caseydk   
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