|
In-Portal Issue Tracker - In-Portal CMS
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
1272 |
[In-Portal CMS] Database |
bug report |
always |
2012-05-06 07:10 |
2012-07-25 05:30 |
|
|
Reporter:
|
alex |
Platform:
|
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
|
Status:
|
closed |
Product Version:
|
5.2.0-B1 |
|
|
Product Build:
|
|
Resolution:
|
fixed |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
5.2.0-RC1 |
|
|
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 |
|
|
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. |
|
Steps To Reproduce:
|
|
|
Additional Information:
|
|
| Relationships | | child of | 0000929 | closed (5.2.0) | alex | Ability to have Preferred Language for Front-end Users |
|
|
Attached Files:
|
 user_frontlanguage_field_wastes_8sqls_each_time.patch (1,498) 2012-05-06 07:10
http://tracker.in-portal.org/file_download.php?file_id=1644&type=bug |
|
|
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 |