The inner workings of Notes when it loads a document

Can anyone elaborate on the inner workings of notes when it loads a document. This is to enable us to better understand some performance issues encountered when using a custom database.

For example, a document may contain 10 fields - one of which may contain an attachment of say 40MB and another may include images etc, pasted in. When notes opens this document does it:

Load the attachment fully into memory?

Require the use of other code to display images, email headers etc?

Check doc link validity?

Run through one large table of all the data in the database to find the data required in this document then create the visible document?

If notes is, in some way, trawling through all the documents to load the chosen document from the view would this mean that having a large number of documents would mean a slower database?

These are all areas I believe may be affecting my database but as I am unsure of the way notes works I cannot pin down the causes of slow document loading time.

Please also note that these problems are encountered on local replicas of the database and when the database is new and has few documents etc there is no noticeable delay in document loading.

Subject: RE: The inner workings of Notes when it loads a document

That’s a lot of information you’re asking for.

I suggest you start with these documents:

Inside Notes: Documentation about Notes architecture

IBM Redbooks Performance Considerations for Domino Applications

Application Performance Tuning, Part 2

To answer briefly, though, your document taking a long time to load has nothing to do with the architecture of Notes and everything to do with the design of your form.

Subject: RE: The inner workings of Notes when it loads a document

Generally, I agree with Andre in what he said, but it has been reported that large attachments may be virus checked when you open the document. If you try with and without the attachment, that should quickly establish how much of a factor that is.

As for the doclink, it is not validated. It is not trawling through all the documents unless you have an embedded view with dates or something along those lines. The design of the form is most likely at fault if it is not the virus checker.