From: Paul R. <pri...@us...> - 2005-10-29 10:11:02
|
Update of /cvsroot/mantisbt/mantisbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15162 Modified Files: changelog_page.php Log Message: Batch 3 of possible 'performance' commits - mainly based on simplifying xdebug output Use the DB result from generating the changelog list, to display the bug information. i.e. add a function to 'load' up a bug information from a previous db result object, as opposed to accessing the db again. note: someone might want to make suggestions on renaming/modifying this api function... changelog_page.php: Before: Cumulative time: 23,045ms DB query: 828 queries, 1.7702s After: Cumulative time: 19,919ms DB query: 209 queries, 0.4154s Index: changelog_page.php =================================================================== RCS file: /cvsroot/mantisbt/mantisbt/changelog_page.php,v retrieving revision 1.15 retrieving revision 1.16 diff -u -d -r1.15 -r1.16 --- changelog_page.php 21 Apr 2005 22:38:03 -0000 1.15 +++ changelog_page.php 29 Oct 2005 10:10:53 -0000 1.16 @@ -85,7 +85,7 @@ $t_version_id = version_get_id( $t_version, $t_project_id ); - $query = "SELECT id, view_state FROM $t_bug_table WHERE project_id='$c_project_id' AND fixed_in_version='$c_version' ORDER BY last_updated DESC"; + $query = "SELECT * FROM $t_bug_table WHERE project_id='$c_project_id' AND fixed_in_version='$c_version' ORDER BY last_updated DESC"; $t_description = version_get_field( $t_version_id, 'description' ); if ( !is_blank( $t_description ) ) { @@ -106,6 +106,8 @@ continue; } + bug_cache_database_result($t_result->fields); + # check limit_Reporter (Issue #4770) # reporters can view just issues they reported if ( ON === $t_limit_reporters && $t_user_access_level_is_reporter && |