Differences

This shows you the differences between two versions of the page.

--- mantisbt:database_optimization [2006/10/30 06:56] – RogerHill
+++ mantisbt:database_optimization [2008/10/29 04:25] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== Database Optimization ======
 This page describes some database optimisations for SQL Server 2000. These are based on Mantis 1.0.2
@@ Line 8: / Line 10: @@
 ===== The Investigation =====
-The investigation of the problem centered on the filter code in code/filter_api.php. The function filter_get_bug_rows() is the core of the bug filtering system.
+The investigation of the problem centered on the filter code in core/filter_api.php. The function filter_get_bug_rows() is the core of the bug filtering system.
 The existing filter_get_bug_rows() function is 813 lines of code - arguably a candidate for some "refactoring with extreme prejudice" however that is beyond the scope of what I was trying to do here, which was to make MANTIS work acceptably under SQL server with more than 1000 open issues.
@@ Line 108: / Line 110: @@
 	#
 </code>
+===== Alternative solution by RZG =====
+NOTE BY RZG:
+My IMHO simpler solution was to use subqueries. With just 2 small changes, we were able to fix the issues described on my company Mantis, which has well over 10000 issues on it. See [[http://www.mantisbt.org/bugs/view.php?id=7516|Issue 7516]].
 ===== How much difference does it make? =====