Fóruns

Início » Liferay Portal » English » Liferay Legacy

Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
xavier yuste
Login slow
13 de Setembro de 2007 09:19
Resposta

xavier yuste

Ranking: New Member

Mensagens: 13

Data de entrada: 26 de Outubro de 2006

Mensagens recentes

Hi,

We are doing Technical test with our portal, which has the following features:

- Liferay 4.2.2 ear with JBoss 4.0.5GA
- Microsoft SQL Server 2005
- jTDS driver
- 200.000 users in User_ table

We make the following stress test 50 users simultaniously making login in portal without think-time. And the results are very slow (60 seconds each user (average)).

Our login process is using database authentication (not LDAP).

We make a redirect from other aplication using MAC SSO.

We use the following url sample:

http://127.0.0.1:8080/c/portal/login?cmd=already-registered&login=liferay.com.1001&password=ZE33URwTiB70WEFNVJFBIw==


The web server cpu % is not stressed, and the database server is not stressed (about 20% of CPU).

We use profiler in Database and the following select sometimes has 0 miliseconds duration but sometimes has 5000 miliseconds:

(SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Groups ON (Users_Groups.userId = 'liferay.com.100283' ) INNER JOIN LayoutSet ON
(LayoutSet.groupId = Group_.groupId) WHERE (Users_Groups.groupId = Group_.groupId) AND (LayoutSet.privateLayout = 1 ) AND (LayoutSet.pageCount != 0) AND
(Group_.companyId = 'liferay.com' ) AND (Group_.className IS NULL OR Group_.className = '') AND (Group_.classPK IS NULL OR Group_.classPK = '') AND (lower(Group_.name) LIKE
NULL OR NULL IS NULL) AND (lower(Group_.description) LIKE NULL OR NULL IS NULL) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_
INNER JOIN LayoutSet ON (LayoutSet.groupId = Group_.groupId) INNER JOIN Groups_Orgs ON (Groups_Orgs.groupId = Group_.groupId) INNER JOIN Users_Orgs ON
(Users_Orgs.organizationId = Groups_Orgs.organizationId) WHERE (LayoutSet.privateLayout = 1 ) AND (LayoutSet.pageCount != 0) AND (Users_Orgs.userId =
'liferay.com.100283' ) AND (Group_.companyId = 'liferay.com' ) AND (Group_.className IS NULL OR Group_.className = '') AND (Group_.classPK IS NULL OR Group_.classPK = '')
AND (lower(Group_.name) LIKE NULL OR NULL IS NULL) AND (lower(Group_.description) LIKE NULL OR NULL IS NULL) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name
AS groupName FROM Group_ INNER JOIN LayoutSet ON (LayoutSet.groupId = Group_.groupId) INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN
Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (LayoutSet.privateLayout = 1 ) AND (LayoutSet.pageCount != 0) AND
(Users_UserGroups.userId = 'liferay.com.100283' ) AND (Group_.companyId = 'liferay.com' ) AND (Group_.className IS NULL OR Group_.className = '') AND (Group_.classPK IS
NULL OR Group_.classPK = '') AND (lower(Group_.name) LIKE NULL OR NULL IS NULL) AND (lower(Group_.description) LIKE NULL OR NULL IS NULL) ) ORDER BY groupName ASC


Does somebody have some idea about how we can increase the performance in login ?

Thanks a lot.
Andy Leung
RE: Login slow
13 de Setembro de 2007 11:58
Resposta

Andy Leung

Ranking: Regular Member

Mensagens: 134

Data de entrada: 4 de Agosto de 2006

Mensagens recentes

Well, there must be workaround but you might have to send the profiler's report to liferay and let them fix that. Seriously 4.3.1 has the same problem and I used Liferay since 4.1.2 and honestly, 4.2.2 was the best so far except performance is an issue. If there are only 10 users on the system it is only with AMD 4000+, 2GB DDR2, Ubuntu Server 7.04. If there are more than 30+ users, it's crazily slow even on a Dual Xeon with 4GB memory.
xavier yuste
RE: Login slow
14 de Setembro de 2007 07:16
Resposta

xavier yuste

Ranking: New Member

Mensagens: 13

Data de entrada: 26 de Outubro de 2006

Mensagens recentes

Hi,

We attach files with SQL profiler trace, and threadDump during login execution.



Thanks a lot.
Anexos: ThreadDump_B.htm (548,5k), ThreadDump_C.htm (394,2k), ThreadDump__A.htm (522,8k), traceSQLProfiler.xls (211,0k)
David H Nebinger
RE: Login slow
27 de Abril de 2012 05:47
Resposta

David H Nebinger

Community Moderator

Ranking: Liferay Legend

Mensagens: 11046

Data de entrada: 1 de Setembro de 2006

Mensagens recentes

You'll get more mileage on your question by posting as a new thread rather than trying to revive dead ones...
streambigs streambigs
RE: Login slow
27 de Abril de 2012 05:54
Resposta

streambigs streambigs

Ranking: New Member

Mensagens: 8

Data de entrada: 27 de Abril de 2012

Mensagens recentes

Thanks David,

I open a new thread at :

http://www.liferay.com/community/forums/-/message_boards/message/13685436
Hitoshi Ozawa
RE: Login slow
27 de Abril de 2012 05:55
Resposta

Hitoshi Ozawa

Ranking: Liferay Legend

Mensagens: 7949

Data de entrada: 23 de Março de 2010

Mensagens recentes

Question moved to a new thread below:

http://www.liferay.com/community/forums/-/message_boards/message/13685436