1 strange view (performance problem solved)

HCL Domino Domino Forum
1

Hi !

i have 1 view that seems to be ‘corrupt’. This view has about 80 documents in it. The view does not have time relative fromulas and the documents do not have reader fields.

This view took about 30 seconds to open for 7 straight times (open the view, close the db and re-open the view). This affected the whole performance of the database as other users saw bad performance during this .

all other views in this database opened quickly and bigger in number of docs and in size of view index.

What is strange is that now, this view is extremely quick and my database performance is at it’s best. Has anyone experienced this with a view ???

I ca reproduce this with my view in my QA database as it takes about 20 seconds to open eache time and has 0 documents in it ???

I do not think it has something to do with the view options because the view is now very quick ( for the past 36 hours)…

any help or comments would be greatly appreciated !!

Thanks in advance

2

Subject: 1 strange view

Can you post the view selection formula- and if there is a sorted/catagorized column- what those formulas are?

3

Subject: 1 strange view (solved)

Hi thanks for the response !!

But i finally found the problem! Here goes :

i found this post on this forum :

http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/bfe5b655af4366918525715b006fc044?OpenDocument&Highlight=0,%24collation

it talks about the ‘$collation’ items in the design elements of the views. Turns out that my view had 14 $collation items. This seems to be a bug since these items are supposed to be for sortable columns (1 per sort). Hence, my view has now only 2 columns that are sortable both ways. So i should have only 4 $collation items, not 14.

So i coded this routine :

Dim s As New NotesSession

Dim db As NotesDatabase

Dim view As NotesView

Dim doc As notesdocument



Set db = s.CurrentDatabase

Set view = db.GetView("SaveConflitsAvecStatut")



Set doc = db.GetDocumentByUNID(view.UniversalID)



For i = 1 To 14

	Call doc.RemoveItem("$collation" & Cstr(i))		

Next

Call doc.Save(True,True)

Then, i re-accessed my view. The first time it was slow as it rebuilded it’s index. But all the other attemps to open the view where instant.

Problem solved !!!