Welcome to the #dominoforever Product Ideas Lab! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated jointly by the IBM & HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino page.


Improve View Update performance in NSF dramatically

As an example, the problem with slow View Update performance becomes most visible with large domlog.nsf or large log.nsf NSF databases.

If there are several million documents, and if several documents are added per second, the View Update may take too long, or the View will "never" open.

Apparently, updating a View seems to be a single-threaded process. If too many documents were added/changed, the Update task will initiate a full View Rebuild, which makes it even worse.

This model limits NSF-based applications to scale per se.

Typical workarounds to this weakness are to use faster storage, or to distribute data accross more databases, which have a smaller amount of documents.

I believe that it should be possible to raise this limitation substantially by introducing a multi-threaded View Update model (multiple threads working on updating a single View in parallel)

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jul 31 2018
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    01 Aug 15:44

    helo

    +1

    it would be excellent to gain an updated view with one million documents in 7sec as in SQL.
    to build into Domino relational structure of view

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    24 Aug 15:14

    It should be possible to mark view indices in applications as non-discardable (like DBMT does to specific mailbox views).

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    27 Aug 14:23

    Since 9.0.1 FP3 the feature 'Dedicated View Thread' https://www-01.ibm.com/support/docview.wss?uid=swg21960257 exists. This let you dedicate a separate thred to a specific view, up to a maximum (as of 9.0.1 FP3) of 25 dedicated threads.  The feature also allows access to the view while it is being updated. This might alleviate some specific pain points in a server.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    13 Sep 09:46

    Many thanks for pointing to the feature 'Dedicated View Thread'. Obviously, it is a very specific workaround. It does not solve the fundamental problem of Domino databases not being able to scale.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    05 Nov 10:42

    +1.