: 4582 | 108668 | 12353

: 36 : 36 : 0 |
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.

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.

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