View Issue Details

IDProjectCategoryView StatusLast Update
0021914mantisbtperformancepublic2017-09-28 02:29
Reportercproensa Assigned Tocproensa  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version1.3.3 
Target Version1.3.4Fixed in Version1.3.4 
Summary0021914: tags column in view-all page issues one query for each bug row
Description

for each bug showed, there is a query to get the tags attached to that bug id.

This could be optimized to get all the tags, for all bugs, with one query.

TagsNo tags attached.

Relationships

related to 0022074 closedcproensa System notice when detaching tags 

Related Changesets

MantisBT: master-1.3.x 4add3ac5

2016-11-13 15:16

cproensa

Committer: dregad


Details Diff
Implement bug tags association cache

Implement a method to cache the tags associated to bugs.
Reduces the number of executed database queries by loading and reusing
all needed values for several bugs.

Fixes: 0021914
Affected Issues
0021914
mod - core/bug_api.php Diff File
mod - core/tag_api.php Diff File
mod - tag_delete.php Diff File
mod - tag_update.php Diff File
mod - tag_update_page.php Diff File
mod - tag_view_page.php Diff File

MantisBT: master-1.3.x 31385f2f

2016-11-25 23:40

dregad


Details Diff
Bug cache performance improvements

Merge of PR https://github.com/mantisbt/mantisbt/pull/948

Fixes 0021900, 0021914
Affected Issues
0021900, 0021914
mod - bug_view_inc.php Diff File
mod - core/bug_api.php Diff File
mod - core/classes/MantisColumn.class.php Diff File
mod - core/custom_field_api.php Diff File
mod - core/tag_api.php Diff File
mod - core/user_api.php Diff File
mod - csv_export.php Diff File
mod - excel_xml_export.php Diff File
mod - my_view_inc.php Diff File
mod - tag_delete.php Diff File
mod - tag_update.php Diff File
mod - tag_update_page.php Diff File
mod - tag_view_page.php Diff File

MantisBT: master 6b0df308

2017-09-18 15:24

cproensa

Committer: dregad


Details Diff
Fix comparing to null from db result

Oracle returns nulls as ''.
Change the check for an empty tags result.

Fixes PR 1154
Related issue: 0021914
Affected Issues
0021914
mod - core/tag_api.php Diff File