mantisbt:database_optimization
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
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 | 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 ===== | ||
- | The investigation of the problem centered on the filter code in code/ | + | The investigation of the problem centered on the filter code in core/ |
The existing filter_get_bug_rows() function is 813 lines of code - arguably a candidate for some " | The existing filter_get_bug_rows() function is 813 lines of code - arguably a candidate for some " | ||
Line 108: | Line 110: | ||
# | # | ||
</ | </ | ||
+ | |||
+ | |||
+ | ===== 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:// | ||
===== How much difference does it make? ===== | ===== How much difference does it make? ===== |
mantisbt/database_optimization.txt · Last modified: 2008/10/29 04:25 by 127.0.0.1