: 4582 | 108668 | 12353

Increase the amount of data formula can output 
Use this IdeaSpace to post ideas about Domino Designer.

: 36
: 36
: 0
: Domino Designer
: formula, @formula, evaluate
: Tommy Valand2746 17 Oct 2008
: / Email
As far as I know, formula can only output 64k of data.

This especially limits the usage of formula in Evaluate-statements.

Formula is --really fast-- compared to LotusScript. Formula has some inbuilt functionality that LS lacks. Two really powerful are @Tranform and @Sort.

Try sorting/filtering an array in LS (code is probably on OpenNTF in the codebin), and then do the same in Formula.

The problem with LS is that it needs a -lot- more code to sort/filter arrays, as there is no API for this in LS, and it is a lot slower (yes, there is Java, but with the current editor, I'm not touching it).

The problem with formula is that it can only output 64k (another problem is that @Sort doesn't like custom sorting of big lists/arrays).

I don't know what limitations there are on server side JS (N8.5). If there are none, and arrays are blindingly fast, I probably won't care about this problem in the future. Throw away the 32k limit on array indexes, and I'll be really happy!

1) Kerr Rainey3860 (22 Oct 2008)
The value of this is limited if you don't have anywhere to put the data. At the moment I'm pretty sure the formula can handle more than 64k of data, you just can't save it.

What we really need is fields with a larger limit. If we had that I suspect that formula would support it.
2) Tommy Valand2746 (22 Oct 2008)
I changed the title. Internally, I think I've read somewhere that formula can work with about 1000k of data.

Evaluate can only output 64k (>64k -> "Cannot evaluate formula"-error). Not sure about the input-limit, but I think it's 64k as well.


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

IdeaJam developed by

Elguji Software Logo