Anonymous | Login | Signup for a new account | 2024-04-20 06:02 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Viewing Issue Advanced Details [ Jump to Notes ] [ Wiki ] | [ View Simple ] [ Issue History ] [ Print ] | ||||||
ID | Category | Type | Reproducibility | Date Submitted | Last Update | ||
0000387 | [In-Portal CMS] Optimization | task | always | 2009-10-13 08:17 | 2010-01-11 22:05 | ||
Reporter | alex | View Status | public | Project Name | In-Portal CMS | ||
Assigned To | alex | Developer | |||||
Priority | normal | Resolution | fixed | Platform | |||
Status | closed | OS | |||||
OS Version | |||||||
ETA | none | Fixed in Version | 5.0.2-B1 | Product Version | 5.0.1 | ||
Target Version | 5.0.2 | Product Build | |||||
Time Estimate | No estimate | ||||||
Summary | 0000387: Sitemap optimization | ||||||
Description | I have pretty small sitemap - 25 sections in total with maximal deep level is 3. There are 149 queries total executed on this page and 4 phrases are loaded by individual queries, however they already should be loaded using cached request (used phrase ids are stored on per template bases in PhrasesCache table). | ||||||
Steps To Reproduce | |||||||
Additional Information | |||||||
Tags | No tags attached. | ||||||
Reference | |||||||
Change Log Message | |||||||
Estimate Points | 0 | ||||||
Attached Files | sitemap_optimization.patch [^] (1,900 bytes) 2009-10-13 08:25 [Show Content] | ||||||
|
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0000891) alex (manager) 2009-10-13 08:25 |
1. 5 database queries were saved on phrase load, because phrases with no_editing parameter specified during their load (in m_Phrase tag) used different caching key, that wasn't recognized by global caching system. 2. 51 database queries, used to calculate Priority field options for every section list were saved. These calculation as useless on Front-End, because nobody uses them. These only useful in administrative console, because there Priority column is shown with all that options. |
(0000911) Dmitry (manager) 2009-10-18 01:58 |
Tested ok. Just a Note that you are using - if (!$this->Application->IsAdmin()) which will be replaced in the other task in 5.0.2. |
(0000985) alex (manager) 2009-10-25 16:05 |
Moving to 5.0.2 release as community input during 5.0.2-B1 version testing. |
(0000986) alex (manager) 2009-10-25 16:09 |
Fix committed to 5.0.x branch. Commit Message: Fixes 0000387: Sitemap optimization |
(0001350) Dmitry (manager) 2010-01-11 22:05 |
Closing completed tasks. |
Related Changesets | |||
In-Portal CMS: 5.0.x r12793 Timestamp: 2009-10-25 16:09:20 Author: alex [ Details ] [ Diff ] |
Fixes 0000387: Sitemap optimization | ||
mod - /in-portal/branches/5.0.x/core/kernel/languages/phrases_cache.php | [ Diff ] [ File ] | ||
mod - /in-portal/branches/5.0.x/core/units/categories/categories_event_handler.php | [ Diff ] [ File ] | ||
Issue History | |||
Date Modified | Username | Field | Change |
2010-01-11 22:05 | Dmitry | Note Added: 0001350 | |
2010-01-11 22:05 | Dmitry | Status | resolved => closed |
2009-10-25 16:09 | alex | Note Added: 0000986 | |
2009-10-25 16:09 | alex | Status | reviewed and tested => resolved |
2009-10-25 16:09 | alex | Fixed in Version | => 5.0.2-B1 |
2009-10-25 16:09 | alex | Resolution | open => fixed |
2009-10-25 16:09 | alex | Changeset attached | 5.0.x r12793 |
2009-10-25 16:05 | alex | Note Added: 0000985 | |
2009-10-25 16:05 | alex | Target Version | Icebox => 5.0.2 |
2009-10-18 01:58 | Dmitry | Note Added: 0000911 | |
2009-10-18 01:58 | Dmitry | Assigned To | !COMMUNITY => alex |
2009-10-18 01:58 | Dmitry | Status | needs testing => reviewed and tested |
2009-10-13 08:25 | alex | Note Added: 0000891 | |
2009-10-13 08:25 | alex | Assigned To | => !COMMUNITY |
2009-10-13 08:25 | alex | Status | active => needs testing |
2009-10-13 08:25 | alex | File Added: sitemap_optimization.patch | |
2009-10-13 08:18 | alex | Description Updated | View Revisions |
2009-10-13 08:17 | alex | Target Version | => Icebox |
2009-10-13 08:17 | alex | New Issue |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |