Tip about 64KB Limits in ND6 formula language
Thu 12 Feb 2004, 04:10 PM
I responded to Rich Schwartz about this, but thought it deserved at least a quick mention here for those who don't know. A certain amount of noise has been made about the 64KB limit being "fixed" or "eliminated" in formula language for ND6. The bad news is, it isn't all the way gone. The good news is, even part way is more useful than it seems.
Bad News First In one of those odd concessions to the difficulty of changing "everything" and thus making do with changing what you can instead, Damien Katz (formerly of Iris/IBM) fixed the formula language for Notes/Domino 6 so that internal results can be greater than 64KB, but not final results. Thus, either
@Unique(@DbColumn("", "", "Main View", 2))
or
@Trim(@Replace(@DbColumn("", "", "Main View", 2); to_eliminate; ""))
could easily have an interim result from the @DbColumn of greater than 64KB which would have blown through the limits in R5, but which will still be acceptable if the end result of the whole formula is less than 64KB.
Good News This is a much bigger gain than you might think, because you can always do something like:
total_count := @Elements(@DbColumn("", "", "Main View", 2));
and then use the new looping constructs to take smaller chunks of data at a time using @Subset. Therefore, even though the bigger promise of not having to worry about the 64KB limits has not been realized, it is still possible to work with much larger result sets with a bit of effort - if you know the trick.
Copyright © 2004 Genii Software Ltd.
|