In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

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 EstimateNo 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 patch file icon user_frontlanguage_field_wastes_8sqls_each_time.patch [^] (1,498 bytes) 2012-05-06 07:10 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
child of 0000929closed (5.2.0)alex Ability to have Preferred Language for Front-end Users 

-  Notes
User avatar (0004619)
alex (manager)
2012-05-06 07:12

Will test all together.
User avatar (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
User avatar (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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker