Anonymous | Login | Signup for a new account | 2024-10-03 14:53 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||
ID | Category | Type | Reproducibility | Date Submitted | Last Update | ||
0001272 | [In-Portal CMS] Database | bug report | always | 2012-05-06 07:10 | 2012-07-25 05:30 | ||
Reporter | alex | View Status | public | Project Name | In-Portal CMS | ||
Assigned To | alex | Developer | |||||
Priority | normal | Resolution | fixed | Fixed in Version | 5.2.0-RC1 | ||
Status | closed | Product Version | 5.2.0-B1 | Target Version | 5.2.0 | ||
Time Estimate | No estimate | ||||||
Summary | 0001272: Extra 8 sqls on each page load | ||||||
Description |
I've recently noticed that during 0000929 development we added a code, that displays all enabled languages in system to user in "Language" field dropdown on his profile page. Problem is that we don't cache it and querying these languages could cost up to 8 sqls each time user object is created. |
||||||
Additional Information | |||||||
Tags | No tags attached. | ||||||
Reference | https://groups.google.com/d/topic/in-portal-bugs/0BY_lJHmKhQ/discussion | ||||||
Change Log Message | Removes extra sqls on language querying | ||||||
Estimate Points | 1 | ||||||
Attached Files | user_frontlanguage_field_wastes_8sqls_each_time.patch [^] (1,498 bytes) 2012-05-06 07:10 [Show Content] | ||||||
|
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||
|
Notes | |
(0004619) alex (manager) 2012-05-06 07:12 |
Will test all together. |
(0004620) alex (manager) 2012-05-06 07:12 |
Fix committed to 5.2.x branch. Commit Message: Fixes 0001272: Extra 8 sqls on each page load |
(0004913) alex (manager) 2012-07-25 05:30 |
Since 5.2.0/1.2.0 versions was released. |
Related Changesets | |||
In-Portal CMS: 5.2.x r15329 Timestamp: 2012-05-06 07:12:55 Author: alex [ Details ] [ Diff ] |
Fixes 0001272: Extra 8 sqls on each page load | ||
mod - /in-portal/branches/5.2.x/core/units/users/users_event_handler.php | [ Diff ] [ File ] | ||
Issue History | |||
Date Modified | Username | Field | Change |
2012-07-25 05:30 | alex | Note Added: 0004913 | |
2012-07-25 05:30 | alex | Status | resolved => closed |
2012-05-06 07:12 | alex | Changeset attached | 5.2.x r15329 |
2012-05-06 07:12 | alex | Note Added: 0004620 | |
2012-05-06 07:12 | alex | Status | reviewed and tested => resolved |
2012-05-06 07:12 | alex | Fixed in Version | => 5.2.0-RC1 |
2012-05-06 07:12 | alex | Resolution | open => fixed |
2012-05-06 07:12 | alex | Assigned To | !COMMUNITY => alex |
2012-05-06 07:12 | alex | Note Added: 0004619 | |
2012-05-06 07:12 | alex | Status | needs testing => reviewed and tested |
2012-05-06 07:12 | alex | Assigned To | => !COMMUNITY |
2012-05-06 07:12 | alex | Developer | => alex |
2012-05-06 07:12 | alex | Status | active => needs testing |
2012-05-06 07:12 | alex | Reference | => https://groups.google.com/d/topic/in-portal-bugs/0BY_lJHmKhQ/discussion |
2012-05-06 07:11 | alex | Relationship added | child of 0000929 |
2012-05-06 07:10 | alex | New Issue | |
2012-05-06 07:10 | alex | File Added: user_frontlanguage_field_wastes_8sqls_each_time.patch | |
2012-05-06 07:10 | alex | Change Log Message | => Removes extra sqls on language querying |
2012-05-06 07:10 | alex | Estimate Points | => 1 |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |