|
In-Portal Issue Tracker - In-Portal CMS
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Type: | Reproducibility: | Date Submitted: | Last Update: |
| 117 | [In-Portal CMS] Database | bug report | always | 2009-07-17 20:45 | 2009-10-03 07:56 |
|
|
|||||
| Reporter: | Dmitry | Platform: | |||
| Assigned To: | alex | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | closed | Product Version: | 4.3.9 | ||
| Product Build: | Resolution: | fixed | |||
| ETA: | none | Fixed in Version: | 5.0.0 | ||
| Reference: | |||||
| Change Log Message: | |||||
| Estimate Points: | 0 | ||||
|
|
|||||
| Summary: | 0000117: Extra SQLs for Locale Selection | ||||
| Description: |
Noticed extra SQLs for Locale Selection. We need to optimize to 1 instead of 4 please see below: Name: SELECT Locale FROM Language WHERE LanguageId = 1 LIMIT 0,1 [Runtime: 0.00059199333190918s] [File: db_tag_processor.php:2133] [Affected Rows: 1] [Result: en-US] [Query Number: 34] Name: SELECT Locale FROM Language WHERE LanguageId = 1 LIMIT 0,1 [Runtime: 0.00062298774719238s] [File: db_tag_processor.php:2134] [Affected Rows: 1] [Result: en-US] [Query Number: 35] Name: SELECT Locale FROM Language WHERE LanguageId = 1 LIMIT 0,1 [Runtime: 0.00061297416687012s] [File: db_tag_processor.php:2133] [Affected Rows: 1] [Result: en-US] [Query Number: 36] Name: SELECT Locale FROM Language WHERE LanguageId = 1 LIMIT 0,1 [Runtime: 0.00057888031005859s] [File: db_tag_processor.php:2134] [Affected Rows: 1] [Result: en-US] [Query Number: 37] |
||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Relationships | |||||
| Attached Files: | |||||
|
|
|||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-10-03 07:56 | administrator | Note Added: 0000662 | |||
| 2009-10-03 07:56 | administrator | Status | resolved => closed | ||
| 2009-07-19 05:49 | alex | version | => 4.3.9 | ||
| 2009-07-19 05:49 | alex | Fixed in Version | => 5.0.0 | ||
| 2009-07-19 05:49 | alex | Note Added: 0000135 | |||
| 2009-07-19 05:49 | alex | Status | reviewed and tested => resolved | ||
| 2009-07-19 05:49 | alex | Resolution | open => fixed | ||
| 2009-07-19 05:49 | alex | Changeset attached | RC r11913 | ||
| 2009-07-17 20:45 | Dmitry | New Issue | |||
| 2009-07-17 20:45 | Dmitry | Status | active => reviewed and tested | ||
| 2009-07-17 20:45 | Dmitry | Assigned To | => alex | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||