Home       About Genii       Products       Downloads       News & Events       Support       Weblog   
March, 2010
SMTWTFS
 01 02 03 04 05 06
07 08 09 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
February, 2010
January, 2010
December, 2009
November, 2009
October, 2009
September, 2009

Show all 82 months


Search the weblog

Ben Langhinrichs
E-mail address - Ben Langhinrichs

Photograph of Ben Langhinrichs



©2003-2009 Genii Software Ltd. All rights reserved. The rights to all logos, images, etc. are owned by their respective owners.

The views expressed in this weblog are mine alone, but since I am President and Owner, they necessarily also reflect the views of Genii Software, Ltd.
Genii Weblog
Genii Weblog

Tip about 64KB Limits in ND6 formula language

Thu 12 Feb 2004, 04:10 PM

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.

What has been said:

117.1. Justin Freeman (02/13/2004 04:43 PM)

Great tip Ben! I had always assumed that the 64kb limit was a "fixed feature" of Notes. Glad to hear that at least there is a workaround.

117.2. Bruce Elgort (02/14/2004 08:34 PM)

Ben,

Thanks for this great tip.

117.3. Kumar (04/29/2005 03:50 AM)

Hi Ben,

I am getting the following errors in R5 application at different scenarios. I would be greatful to you, if you can help me.

(a) Field is too large (32k) or view's column & selection formula is too large

(b) Paragraph or Field cannot be larger than 64k bytes

Thanks & Regards,

Kumar.

117.4. AJP (02/10/2006 03:36 AM)

This very useful bit of functionality has been killed off by IBM in 7.0.1. So much for full backward compatibility.

http://www-10.lotus.com/ldd/r5fixlist.nsf/8ed1b46cfdba8957852570c90054623b/1dc32adb85da571c852570ef00111203?OpenDocument

Why have they done that?

117.5. Ben Langhinrichs (02/10/2006 04:16 AM)

I can only say this is a mystifying turn of events. I have heard no reason for it yet, but it is very unlike IBM unless a huge security hole was opened by it (which is possible).

117.6. Uttam Dutta (03/25/2008 09:50 AM)

Hello,

We are getting 32K Error while saving Notes document. Max text size in a single field in not exceeding 32K and also none of these fields are view columns. However, the total size of document is reaching 64K (excluding attachments). We are getting this error while trying to save the document and its not allowing us to save the document.

I have tested by deleting fields from a section on the document, that has multi-value fields, that reduced the size of document way below 64K, and then I was able to continue saving the document.

Do you suggest anything that I can perhaps do?

Thanks in advance.

Uttam

Have your say:

Name *:
E-mail:
e-mail addresses will not be displayed on this site
Comment *:


<HTML is not allowed>
Linking: Add links as {{http://xxx|title}}, and they will be activated once approved
Blocked? Unable to post a comment? Please read this for a possible explanation...

Copyright © 1996-2009 Genii Software Ltd. All Rights Reserved. Some images courtesy of BigFoto.com  Nedstat