Anonymous Login
2019-07-21 10:19 PDT

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0001558Pending RequestsProject Designerpublic2016-12-26 10:25
Reporteropto 
Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0001558: bad efficiency of update tasks
Descriptioneven if only % is changed, we always store.

update sql might be better. In storing, we always update dynamics etc which is only necessary on date changes or relationship changes

it is ca. 5000 queries to change % on 120 tasks, taking 20 seconds
TagsNo tags attached.
Attached Files

-Relationships
has duplicate 0001532closedcaseydk v3.2 Release bulk changing tasks (end date) takes ages -> php timeout 
+Relationships

-Notes

~0003420

caseydk (administrator)

The problem is that we don't know what has changed.. we're not doing any sort of audit logging or field change tracking. I'm going to push this to v4.0 so we can rethink tasks as a whole instead of these piecemeal solutions.
+Notes

-Issue History
Date Modified Username Field Change
2014-05-29 13:24 opto New Issue
2014-06-06 21:07 caseydk Relationship added has duplicate 0001532
2014-06-06 22:23 caseydk Note Added: 0003420
2014-06-06 22:23 caseydk Project v3.2 Release => v4.0 Release (Planning)
2014-06-10 22:49 caseydk Target Version => 4.0
2016-12-26 10:25 caseydk Project v4.0 Release (Planning) => Pending Requests
+Issue History