Performance problem

HCL Domino Domino Forum
1

Hi All,

i have a database which contains about 180000 documents and about 120 views. The type of about 100 views are shared and of about 20 are shared desktop private on first use. So, while the updater task work on views which type are shared desktop private on first use the database performance are very low.

What will be the best solution to solve this problem? Have anybody a good idea or advice?

Many thanks,

Peter

2

Subject: performance problem

Peter,

I’ve seen this problem before and never was able to pin down exactly what was slowing down performance. There may be multiple factors that have to be in play.

There are plenty of other reasons why I don’t particularly like spofu views, especially for large applications (200k docs). I think there are usually plenty of options, and if it were my app I would explore them.

regards,

raphael

3

Subject: RE: performance problem

for more performane use transaction logging (see help)

4

Subject: performance problem

some technical tips:

  • define the most simpliest view of your db as “default view” (DB will open quicker)

  • avoid as many custom column sorting possibilities as possible

  • define the index to rebuild manually or periodically where it is possible

some concept issues:

  • could you maybe archive some documents in order to have more smaller db’s (e.g. 1 for each year)

  • could you have documents of different types/forms? you may store them in different db’s

we have also a customer who hase a huge amount of documents.

Some other stuff we made (in addition to the ones mentioned above):

  • Archiving (State and time archiving)

  • Using different DB’s for each Business Unit / Division

  • Building a report tool in order to throw away many views…

  • Setting the view index build manually and let a java agent run periodically (1 hour) through the defined views and refresh the index

I hope some of these tips help

yours…

5

Subject: RE: performance problem

Hi all!

Thank you for your help and advises! I can delete the private views from my database on the Domino server easy. I changed any views refresh interval from automaticaly and i got an excellent performance in my application!

Many thanks,

Peter