Manage Learn to apply best practices and optimize your operations.

Improve Database Performance When Viewing Complex Column Formulas

If you, like me, create complex column formulas to display nicely formatted views using HTML, you may have noticed that the database performance is slow.

When a column formula have calculations, instead of just a simple field reference, database performence suffer.

The solution is to create a computed field on the form that compute the HTML (or any complex formula) and store it in the document. Now you only need to reference the field in your column formula.

This not only speed up the database, but also makes for less coding as you sometimes can re-use the same field in several views.

Dig Deeper on Domino Resources - Part 7

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...