- 
OK, start checking your collations
Category None
Bookmark :
1,5 year ago IBM published a knowledge item about a bug in the Notes designer. Link In short, in a pre 7.0.2 designer client when you remove a sort option from a column and save the view the reference to the sort option, saved in fields called $collation[x], is not removed.
Bookmark :
1,5 year ago IBM published a knowledge item about a bug in the Notes designer. Link In short, in a pre 7.0.2 designer client when you remove a sort option from a column and save the view the reference to the sort option, saved in fields called $collation[x], is not removed.
Today after debugging a big application that had major performance issues after an upgrade I found out that the problems were caused by this bug. The developer had removed a lot of sort options from a lot of views. Since then updating these views would take extremely long each time (f.i. 10 minutes for a updall -T on a view with 120.000 documents) causing semaphore timeouts and causing users to be unable to open the database. After opening and saving these views in a Notes 8 client the same view index was updated in about a second.
So if you have any applications with performance issues, check your views for $collation[x].
To check a view open the database in the designer client, goto views, select the view you want to check (don't open it!), right click and select Design Properties. On the second tab you will see all design elements, including the $collation fields.
The number of $Collation fields represents the number of columns that have sorting properties set (f.i. make a column sort on click). If the number of $Collation fields exceeds the number of columns with sort properties, just save the view with a 7.0.2 or newer client and the $collation fields will be gone.
So if you have any applications with performance issues, check your views for $collation[x].
To check a view open the database in the designer client, goto views, select the view you want to check (don't open it!), right click and select Design Properties. On the second tab you will see all design elements, including the $collation fields.
The number of $Collation fields represents the number of columns that have sorting properties set (f.i. make a column sort on click). If the number of $Collation fields exceeds the number of columns with sort properties, just save the view with a 7.0.2 or newer client and the $collation fields will be gone.