Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Tuomo Kujanpää
Liferay CE 6.1 GA2 performance
August 18, 2014 1:01 AM
Answer

Tuomo Kujanpää

Rank: Junior Member

Posts: 30

Join Date: January 3, 2008

Recent Posts

Hi All,

We have Liferay CE 6.1 GA2 installed on the server and there are some performance issues, e.g. Web Content Portlet opens very slowly to editing mode (15-25 secs).

==> Do You have any ideas, how to boost the performance when the (private) Site has 3285 pages?

BR,

Tuomo
Ravi Kumar Gupta
RE: Liferay CE 6.1 GA2 performance
August 18, 2014 2:37 AM
Answer

Ravi Kumar Gupta

Rank: Liferay Legend

Posts: 1230

Join Date: June 23, 2009

Recent Posts

Try to run ySlow plugin of firefox on your site. See what are the issues it is reporting, and if they can be resolved.
David H Nebinger
RE: Liferay CE 6.1 GA2 performance
August 18, 2014 6:18 AM
Answer

David H Nebinger

Rank: Liferay Legend

Posts: 7451

Join Date: September 1, 2006

Recent Posts

Tuomo Kujanpää
RE: Liferay CE 6.1 GA2 performance
August 26, 2014 7:44 AM
Answer

Tuomo Kujanpää

Rank: Junior Member

Posts: 30

Join Date: January 3, 2008

Recent Posts

Thanks for your replies!

We found that 15-25 secs are consumed in the LayoutPersistenceImpl.findByG_P method when the Web Content Display portlet is opened to the editing mode. The general performance of our portal is fine, only the problem mentioned when opening web content.

It seems that the poor performance with web content editing correlates with the amout of pages in Site. Any ideas to overcome this? Or any version specific hints / observations?
Vilmos Papp
RE: Liferay CE 6.1 GA2 performance
August 26, 2014 7:51 AM
Answer

Vilmos Papp

LIFERAY STAFF

Rank: Expert

Posts: 467

Join Date: October 21, 2010

Recent Posts

Can you check what type of indexes are on the Layout table? Perhaps the relevant index is missing.
Harri Tuomela
RE: Liferay CE 6.1 GA2 performance
August 28, 2014 7:19 AM
Answer

Harri Tuomela

Rank: Junior Member

Posts: 33

Join Date: February 3, 2008

Recent Posts

Hi!

Liferay has autogenerated these indexes:
 1CREATE INDEX ix_1a1b61d2 ON layout USING btree (groupid, privatelayout, type_);
 2CREATE INDEX ix_23922f7d ON layout USING btree (iconimageid);
 3CREATE INDEX ix_6de88b06 ON layout USING btree (groupid, privatelayout, parentlayoutid);
 4CREATE INDEX ix_705f5aa3 ON layout USING btree (groupid, privatelayout);
 5CREATE UNIQUE INDEX ix_7162c27c ON layout USING btree (groupid, privatelayout, layoutid);
 6CREATE INDEX ix_8ce8c0d9 ON layout USING btree (groupid, privatelayout, sourceprototypelayoutuuid);
 7CREATE INDEX ix_b529bfd3 ON layout USING btree (layoutprototypeuuid);
 8CREATE UNIQUE INDEX ix_bc2c4231 ON layout USING btree (groupid, privatelayout, friendlyurl);
 9CREATE INDEX ix_c099d61a ON layout USING btree (groupid);
10CREATE INDEX ix_c7fbc998 ON layout USING btree (companyid);
11CREATE UNIQUE INDEX ix_ced31606 ON layout USING btree (uuid_, groupid);
12CREATE INDEX ix_d0822724 ON layout USING btree (uuid_);

The third one
1CREATE INDEX ix_6de88b06 ON layout USING btree (groupid, privatelayout, parentlayoutid);
matches to the where clause of an SQL statement
 1SELECT layoutimpl0_.plid AS plid14_
 2    ,layoutimpl0_.uuid_ AS uuid2_14_
 3    ,layoutimpl0_.groupId AS groupId14_
 4    ,layoutimpl0_.companyId AS companyId14_
 5    ,layoutimpl0_.createDate AS createDate14_
 6    ,layoutimpl0_.modifiedDate AS modified6_14_
 7    ,layoutimpl0_.privateLayout AS privateL7_14_
 8    ,layoutimpl0_.layoutId AS layoutId14_
 9    ,layoutimpl0_.parentLayoutId AS parentLa9_14_
10    ,layoutimpl0_.NAME AS name14_
11    ,layoutimpl0_.title AS title14_
12    ,layoutimpl0_.description AS descrip12_14_
13    ,layoutimpl0_.keywords AS keywords14_
14    ,layoutimpl0_.robots AS robots14_
15    ,layoutimpl0_.type_ AS type15_14_
16    ,layoutimpl0_.typeSettings AS typeSet16_14_
17    ,layoutimpl0_.hidden_ AS hidden17_14_
18    ,layoutimpl0_.friendlyURL AS friendl18_14_
19    ,layoutimpl0_.iconImage AS iconImage14_
20    ,layoutimpl0_.iconImageId AS iconIma20_14_
21    ,layoutimpl0_.themeId AS themeId14_
22    ,layoutimpl0_.colorSchemeId AS colorSc22_14_
23    ,layoutimpl0_.wapThemeId AS wapThemeId14_
24    ,layoutimpl0_.wapColorSchemeId AS wapColo24_14_
25    ,layoutimpl0_.css AS css14_
26    ,layoutimpl0_.priority AS priority14_
27    ,layoutimpl0_.layoutPrototypeUuid AS layoutP27_14_
28    ,layoutimpl0_.layoutPrototypeLinkEnabled AS layoutP28_14_
29    ,layoutimpl0_.sourcePrototypeLayoutUuid AS sourceP29_14_
30FROM Layout layoutimpl0_
31WHERE (layoutimpl0_.groupId = $1)
32    AND (layoutimpl0_.privateLayout = $2)
33    AND (layoutimpl0_.parentLayoutId = $3)
34ORDER BY layoutimpl0_.parentLayoutId ASC
35    ,layoutimpl0_.priority ASC
which is run for each page (why?!?) of the current site when opening Web Content Portlet... in our case several thousand times since we have several thousand pages in a single site.

None of the indexes matches to the order by clause of the statement so we created also index
1create index layout_parentlayoutid_priority_idx on layout (parentlayoutid,priority);
but it didn't help.
Tuomo Kujanpää
RE: Liferay CE 6.1 GA2 performance
August 29, 2014 12:16 AM
Answer

Tuomo Kujanpää

Rank: Junior Member

Posts: 30

Join Date: January 3, 2008

Recent Posts

Hi Vilmos,

Vilmos Papp:
Can you check what type of indexes are on the Layout table? Perhaps the relevant index is missing.


Please, check below Harri´s answer about the indexes on the Layout table.

BR,

Tuomo
Olaf Kock
RE: Liferay CE 6.1 GA2 performance
August 29, 2014 3:13 AM
Answer

Olaf Kock

LIFERAY STAFF

Rank: Liferay Legend

Posts: 2021

Join Date: September 23, 2008

Recent Posts

As CE only gets updates until the next version is out, and 6.2 is out now for quite a while, I'd like to suggest that you check if the problem still persists on 6.2 - if it doesn't, it's probably a fixed issue and you can try to locate it on issues.liferay.com - if necessary, backport (locate the issue number on the sourcecode (https://github.com/liferay/). Or "just" update to 6.2 (no pun intended).

Not to have too much of a sales pitch here, 6.1 EE is still well supported for a while, in case you don't want to do a major version update now and can't backport.

This is probably not the answer you're looking for, but I currently can't set aside some time to dig deeper and test/reproduce. Sorry