Login slow

[xavier yuste, modificado 16 Anos atrás.]

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, modificado 16 Anos atrás.]

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, modificado 16 Anos atrás.]

Hi,

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



Thanks a lot.

[David H Nebinger, modificado 11 Anos atrás.]

You'll get more mileage on your question by posting as a new thread rather than trying to revive dead ones...

[streambigs streambigs, modificado 11 Anos atrás.]

Thanks David,

I open a new thread at :

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

[Hitoshi Ozawa, modificado 11 Anos atrás.]

Question moved to a new thread below:

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