We are using BO ver 5.1.2 and looking at ways to improve the performance of logging into BO as well as sending/retrieving reports from the repository - it seems to be getting slower and slower.
Can anyione suggest any good ways to do this?
Was going to get DBA to see whether additional indices could be added to the tables concerned (OBJ_X_DOCUMENTS,OBJ_M_DOCUMENTS) .
Which Oracle table does BO look at when user logs into BO?
Thanks
Rachael
RachaelC (BOB member since 2006-11-16)
Playing with Repository tables is not the best way and is unsupported.
Rather do the following:
-check the network, the repository database server.
-delete unwanted reports/universes from repository.
-run scan/repair of different repository domains from Supervisor.
Hyder
haider 
(BOB member since 2005-07-18)
There are many tings you can do:
1 backup your database
2 run a scan and repair
3. Check your folder structure if it is very deep it will take longer.
4. Clean up the inbox folders if you use the BCA you may have quiet a few documents
Outside of BO on the database you may want to
Indexes can help but on the obj_m_actor table and the res-link-tables
OBJ_X_DOCUMENTS does hold the BInary content of the files it will be typically very big. Indexes don’t really help there.
All that should improve your performance.
ClaireB 
(BOB member since 2002-08-09)
(BOB member since 2003-11-27)