Anonymous | Login | Signup for a new account | 2024-03-29 08:16 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Relationship Graph | [ View Issue ] [ Dependency Graph ] | |||
|
||||
|
Viewing Issue Simple Details | |||||
ID | Category | Type | Reproducibility | Date Submitted | Last Update |
0001320 | [In-Portal CMS] Optimization | task | always | 2012-06-12 04:30 | 2012-07-25 05:29 |
Reporter | Dmitry | View Status | public | ||
Assigned To | alex | ||||
Priority | normal | Resolution | fixed | ||
Status | closed | ||||
Summary | 0001320: Improving page detection sql | ||||
Description |
Currently we have the following SQL (actual ids are not important here) to select/find ID of currently loaded Category. SELECT CategoryId FROM Categories WHERE ( (NamedParentPath = 'index') OR (NamedParentPath = 'Content/index') OR (`Type` = 2 AND CachedTemplate = 'index') ) AND (ThemeId = 8 OR ThemeId = 0) This can become a problem when you have high number of Categories/Sections (ie. 3K+, but not a problem for small websites) since NamedParentPath is a TEXT field and can't be properly cached. It would be quite an improvement if we start using Hash (int) column which can be Indexed quite well. Additionally we might want to INDEX Type field too! |
||||
Additional Information |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |