Very slow portal when using many shared pages

Ok, thanks, will try this.


Paul M wrote:
> Well, we had these big querues too, here is one we had in the past:
>
> SELECT DISTINCT SECURITYACCESSRIGHTS.FWELEMENTIID FROM SECURITYACCESSRIGHTS
> WHERE SECURITYACCESSRIGHTS.FWELEMENTIID IN
> ('c373e9112bf283c2ecdb0017085b0611', 'c373e910fb227b0f73030017085b0611',
> 'c373e910e5159b295b3c0017085b0611', 'c373e910c100569a6a1f0002a54868ba',
> 'c373e910fb2279dd96af0017085b0611', 'c373e910fb2236b428d50017085b0611',
> 'c373e910fb230b6def570017085b0611', 'c373e912fbbe7cd1e2bf00110a59dbb6',
> 'c373e912dd265b67660a00110a59dbb6', 'c373e912fb78e0fe611400110a59dbb6',
> 'SinglePortletSharedPage', 'c373e912c3b85f48e3a000110a59dbb6',
> 'c373e912c3b85f6ce84700110a59dbb6') AND SECURITYACCESSRIGHTS.PERMISSIONID =
> 2 AND (SECURITYACCESSRIGHTS.IID NOT IN(SELECT
> SECURITYPERMISSIONS.PERMISSIONIID FROM SECURITYPERMISSIONS WHERE
> LOWER(SECURITYPERMISSIONS.PRINCIPALNAME) IN
> ('ldaprealm\cn=testwally3,ou=test,ou=users,o=hsb,c =nl',
> 'ldaprealm\cn=portal_dms,ou=portal,ou=dif-ict,ou=dif,ou=org,o=hsb,c=nl',
> 'ldaprealm\cn=portal_users,ou=portal,ou=dif-ict,ou=dif,ou=org,o=hsb,c=nl',
> 'ldaprealm\c=nl', 'ldaprealm\o=hsb,c=nl', 'ldaprealm\ou=users,o=hsb,c=nl',
> 'ldaprealm\ou=test,ou=users,o=hsb,c=nl', 'ldaprealm\')) OR
> SECURITYACCESSRIGHTS.IID IN(SELECT SECURITYPERMISSIONS.PERMISSIONIID FROM
> SECURITYPERMISSIONS WHERE SECURITYPERMISSIONS.PRINCIPALNAME =
> 'ffffffffffffffffffffffffffffffff'))
>
>
> But after the patch, these queries were much shorther, we have the same
> amount of records in the security tables. Request the patch, you will be
> happy.
>
> Paul
>