[LPE-4042] Improved performance of database queries - Liferay Issues

XML

Word

Printable

Details

Type: Improvement
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 5.1 EE SP5 (5.1.8), 5.2 EE SP5 (5.2.9) , 6.0 EE SP1 (6.0.11)
Fix Version/s: 5.1 EE SP6 (5.1.9), 5.2 EE SP6 (5.2.10), 6.0 EE SP2 (6.0.12)
Component/s: Performance
Labels:
None

Description

Improved performance of database queries related to finding organization, groups, and message boards by including the company ID in the query so that database indexes can be used.

Attachments

Issue Links

is related to

LPS-14441 Add companyId as join condition to allow query optimizer to know it can use unique indexes

Closed

LPS-14442 Speed up staging community verification for VerifyGroup

Closed

Activity

People

Assignee:: Samuel Kong

Reporter:: Brian Chan

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 22/Dec/10 5:04 PM

Updated:: 09/Dec/16 2:06 PM

Resolved:: 07/Jan/11 2:28 PM

Packages

Version	Package
5.1 EE SP6 (5.1.9)
5.2 EE SP6 (5.2.10)
6.0 EE SP2 (6.0.12)