Slow Login Time

[slinc]

Hello,

We've been experiencing problems with slow login times to Business Objects.

We've applied the necessary repository indexes, removed any non-users from Supervisor, removed the timestamp option from Supervisor, and run the scan/repair/compact utility on the document and security domains to no avail. We've rationalised the number of groups in Supervisor, and do not have more than 3 levels of nesting but it is still taking over 2 mins to log in, compared with around 10 secs just a few months ago.

There have been no specific changes made over the last couple of months to account for this, apart from the standard growth in number of reports published (currently at around 3000). Not sure whether this impacts on login times?

Can anyone offer any other suggestions please? Also, does anyone know the SQL for the login process so I can try and run directly against the repository database (Oracle 9i) to find out whether it is the database rather than Business Objects which may be causing the problem.

Many Thanks

 

[blom0344]

My advice would be to 'capture' the SQL that is directed against the repository database through a DBA tool (like for instance TOAD ;

http://www.quest.com)

This will allow you to run an explain plan to test the SQL. The number of reports should be irrelevant for the login time, but perhaps someone has altered things within ORACLE itself?

However - in my case - , when monitoring DB2 I notice that logging in does not create a capturable SQL statement

Ties Blom
Information analyst

 

[slinc]

Thanks for the feedback. I've tried capturing the SQL as suggested to no avail.

I'm starting to think that it is not the Oracle database (repository) which is causing the problem. Does anyone know the recommended size of the bomain.lsi files please? Ours are around 130KB, so I'm wondering whether this is too large. If so, not sure how I go about reducing the size, even a user who only belongs to one group generates a 90KB .lsi file.

 

[slinc]

Managed to resolve the slow login problem by linking and unlinking resources in Supervisor. I had previously linked all documents, and then just disabled/enabled for different users and groups of users. This appears to have been the cause of the slow login time. I've now rationalised the groups in supervisor, and used linking and unlinking rather than disabling/enabling, and the login speeds are now less than 10 secs.

 

[blom0344]

Congrats, good of you to post the solution (quite a few forget, which is a bit of a shame)

Ties Blom
Information analyst