0020258: Cache user data for my_view_page - MantisBT - Signup temporarily disabled due to spam

ID	Project	Category	View Status	Date Submitted	Last Update

0020258	mantisbt	performance	public	2015-11-05 15:11	2016-06-12 00:42

Reporter	cproensa	Assigned To	cproensa
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	fixed
Product Version	1.3.0-beta.3
Target Version	1.3.0-rc.2	Fixed in Version	1.3.0-rc.2

Summary	0020258: Cache user data for my_view_page
Description	when loading "my_view_page.php", the script does a sql query for each user that appears in the bug result set. This can be optimized by caching all the user data before printing the bug rows
Tags	No tags attached.

cproensa 2015-11-05 15:16 developer ~0051819	PR: https://github.com/mantisbt/mantisbt/pull/675

cproensa 2015-11-22 14:03 developer ~0051913	to be precise here: It's the 'reporter' users who are not being cached

dregad 2015-12-09 05:37 developer ~0052085	Many thanks for your contribution.

MantisBT: master 7f997e87 2015-11-05 10:03 cproensa Committer: dregad Details Diff	Cache reporter user data in view_all_bug_page Add the reporter id to the array of users to be cached from the bug filter result. This saves later individual sql queries from user_cache_row() Changed the temporary arrays to be associative indexed by id, so we don't need to call 'array_unqiue' later. Fixes 0020258 Signed-off-by: Damien Regad <dregad@mantisbt.org>		Affected Issues 0020258
	mod - view_all_bug_page.php		Diff File