View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005928 | mantisbt | performance | public | 2005-07-12 17:33 | 2007-10-04 01:41 |
Reporter | MattB | Assigned To | thraxisp | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.0.0a2 | ||||
Fixed in Version | 1.0.0rc1 | ||||
Summary | 0005928: Pre-cache the available projects speeds up every page significantly | ||||
Description | Working on further speed improvements, I noticed that Mantis sends an individual query out for every project when building the project list at the top of every page. By retrieving and caching all available projects first, the list can be built much quicker. Added this function to project_api.php: function project_cache_rows( $t_project_ids ) {
} Then simply call this function from print_project_option_list, line 364: project_cache_rows($t_project_ids); | ||||
Tags | No tags attached. | ||||
This function already exists as project_cache_all(). |
|
Submitted to CVS. core/print_api.php -> 1.142 |
|
project_cache_all does (as its name suggests) cache ALL project rows from the DB. My implementation caches only those projects to which the user has access - therefore is slightly faster and more secure. Both solutions speed up the system, however. |
|