0026167: Issue view history api repeated calls to bug_get_attachments database query

ID	Project	Category	View Status	Date Submitted	Last Update
0026167	mantisbt	performance	public	2019-09-21 20:32	2019-12-09 04:31

Reporter	cproensa	Assigned To	cproensa
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	fixed
Product Version	2.23.0
Target Version	2.23.0	Fixed in Version	2.23.0

Summary	0026167: Issue view history api repeated calls to bug_get_attachments database query
Description	After the change to rest api issue view, i have detected that the query for `bug_get_attachments()` is repeated for each history row.
Tags	No tags attached.
Attached Files	imagen.png (135,983 bytes) imagen.png (135,983 bytes)

MantisBT: master 1436e536 2019-09-21 16:21 cproensa Committer: dregad Details Diff	Clean up duplicated query call Move the call to `file_get_visible_attachments()` outside of the loop, to avoid duplicated database queries. Fixes: 0026167		Affected Issues 0026167
	mod - api/soap/mc_issue_api.php		Diff File

cproensa 2019-09-22 10:17 developer ~0062886	https://github.com/mantisbt/mantisbt/pull/1568