Optimize document table map and dcouments with no Form field

HCL Domino Domino Forum
1

This is just a warning on something that caught me out.

While doing some testing on a new version of a Notes system, we discovered that a heap of documents were not displayed in views using a select clause like Form = “Index Entry”:“”. Some tinkering found that Form = “Index Entry” | Form = “” | @IsUnavailabl(Form) displayed the required records.

The previous version had used the same selection criteria and had worked OK.

The only difference is that I had switched on the Optimize Document Table Map advanced option. Looks like the way the table map works with the Select clause doesnt cope well with documents having no Form field.

Hope this helps someone.

2

Subject: Optimize document table map and dcouments with no Form field

Good to know.

It does not contradict the documentation, though, I tend to think. When I remember right, even the latest articles on Domino 7 performance on developerWorks mentioned, that this database property is intended for directory-liek databases in the very first place, and that even then, it doesn’t really achieve a noteworthy improvement.