Second Signal Logo

Limits in Notes



Now Available 2.0!
Web Services Enabled
    Our newly released NCT Search 2.0 gives you the power to search across multiple Lotus Notes databases on the fly! Take control of your searches without the overhead of additional indexes. Search only the databases you want, when you want, and make the results display the way you want. NCT Search is your answer to multi-database searches.

    Click here for informtion, Live Demo, and a free trial!


This document has been prepared and managed by Mike Woolsey of Solutions by Design. He posted this for Partners with persmission to give to any Lotus Customer. He is to be thanked heartily for this compilation.

_________________________________________________________________________________________

If you know of any errors in this list, let us know.

This is not documentation; it's what you can expect from R5 and R6 by way of limitations, if you don't know better. If you do know better, we'd like to!

Below is a GUESS at what R6 looks like, known questionable entries have a question mark (?) beside them. Changes in magenta (older, but still new) and red (newer). Answers directly from Lotus or Iris in black.

Almost everything in R6 is simply copied from the R5 column at present.

Anyone knowing more limitations, please let me know and I'll update this doc. If I miss a limitation you mention elsewhere, lemme know.

Some of this is copied from the R4, R5 and R6 Help database.

LimitR5 (LotusScript 4)R6
What is the maximum size of a database?64 GB (gigabyte) or the OS file system's limit (2 GB on some older UNIX platforms)64 GB (gigabyte) or the OS file system's limit (2 GB on some older UNIX platforms)
What is the maximum size of plain text fields?
(What is the maximum size of a group Members field?)
15KB per (summary) text field;
30KB of fields per document (storage); 15KB displayed in a view's column
15KB per (summary) text field;
30KB of fields per document (storage); 15KB displayed in a view's column
What is the maximum size of a computed text field??64,363 characters?64,363 characters
What is the maximum size of a single paragraph in a rich text field?64KB (this is approximately 35k of text, though)64KB (this is approximately 35k of text, though)
What is the maximum number of paragraph styles?64,000 unique paragraph styles in a single document64,000 unique paragraph styles in a single document
How many sublevels in a hierarchical view; how many documents at each level?31 levels; 300,000 documents31 levels; 300,000 documents
What is the maximum number of windows you can have open simultaneously?limited by memory; 35(?) accessible from keyboardlimited by memory; 35(?) accessible from keyboard
How many characters are allowed in names for views, forms, and so on?Database Title: 32
Filename: limited by OS's file system
Field names: 32
View names: 64
Form names: 32
Macro names: 32
Database Title: 32
Filename: limited by OS's file system
Field names: 32
View names: 64
Form names: 32
Macro names: 32
How many aliases are allowed for views?Up to 130 characters for all view aliases per view, including vertical-bar separators ("|"), including the view nameUp to 130 characters for all view aliases per view, including vertical-bar separators ("|"), including the view name
What is the maximum size for Mail recipient names?2MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing).2MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing).
How many mail rules in a mail DB?50100
What's the maximum password length allowed on an ID?63 characters63 characters
fields in a database~ 3000 (limited to ~ 64K total length for all field names). You can enable the database property "Allow more fields in database" to get up to 22,893 uniquely-named fields in the database.~ 3000 (limited to ~ 64K total length for all field names). You can enable the database property "Allow more fields in database" to get up to 22,893 uniquely-named fields in the database.
How many fields in a form?10MB memory (6MB memory for OS/2)10MB memory (6MB memory for OS/2)
columns in one table6464
rows in one table255255
views in a databaseNo limit; however, as the number of views increases, the length of time to display other views also increases No limit; however, as the number of views increases, the length of time to display other views also increases
forms in a databaseUnlimitedUnlimited
columns in a view289 ten-character columns; dependent upon # or characters per column289 ten-character columns; dependent upon # or characters per column
How wide can a column be (# of inches)??15KB displayed in a view's column (5.0.3 release notes)?15KB displayed in a view's column (5.0.3 release notes)
What's the largest view column title allowed?50 characters80 characters
What is the total size of computable simple text fields?63K63K
How many paragraphs in a document?21,509 (19,004 for OS/2)21,509 (19,004 for OS/2)
What is the maximum size of a rich text field?Limited only by available disk space up to 1GBLimited only by available disk space up to 1GB
What is the maximum number of inserted page breaks?UnlimitedUnlimited
How many documents can be imported into a view??(the original (col. 2) has something wrong, syntactically, maybe it's)
Individual documents: up to 350K;
from a spreadsheet, 8192 rows;
5000 separate documents
?(the original (col. 2) has something wrong, syntactically, maybe it's)
Individual documents: up to 350K;
from a spreadsheet, 8192 rows;
5000 separate documents
cascading views in a database200200
How many copies of a document can be printed at once?65,53565,535
What is the maximum value allowed in "Start page numbers at" field?65,53565,535
margin size (in inches)4646
page cropping size (in inches) 4646
point size to select/print250250
maximum number of soft-deleted documents in a database1000 Database 'Partner Forum 2002', View '1. All Posts', Document 'Limit is 1000 in R5.x'32,768 Database 'Partner Forum 2002', View '1. All Posts', Document 'Limit is 1000 in R5.x'
documents in a viewMaximum of 128 GB for a view index.
(16 Mpage of B-tree space, 8kB/page)
Also limited by available disk space (2 GB on some UNIX platforms).

View containers in R5 databases (ODS 3.1 up) do not have a container size limit. The view size limit is now determined by the maximum number of pages that can be created which is 16,777,214. A page holds 8 KB so that means the maximum size for a view is 137,438,937,088 bytes (128 GB).
Maximum of 128 GB for a view index.
(16 Mpage of B-tree space, 8kB/page)
Also limited by available disk space (2 GB on some UNIX platforms).

View containers in R5 databases (ODS 3.1 up) do not have a container size limit. The view size limit is now determined by the maximum number of pages that can be created which is 16,777,214. A page holds 8 KB so that means the maximum size for a view is 137,438,937,088 bytes (128 GB).
What's the maximum number of profile documents allowed in a database?6000-6100 per database Database 'Lotus Notes Knowledge Base', View '1) Knowledge Base\All Info - Flat Search View', Document '"Profile document enumeration pool is full" when using GetProfileDocCollection': s/w limitationaround 6000-6100 per database: s/w limitation
What is the maximum number of documents that can be exported to Tabular Text?Limited only by available disk spaceLimited only by available disk space
How many levels of responses will display in a view?31 levels of response to 1 main document31 levels of response to 1 main document
How many responses per parent document? (bug:15,796 responses per document Database 'Lotus Notes Knowledge Base', View '1) Knowledge Base\All Info - Flat Search View', Document 'Creating a Response Document Results in an Error, Typically "#13:C8", or "B-tree Structure Invalid"' in R5 to 5.0.10)??
What is the maximum number of entries in an Access Control List?950 names
(I don't know if this has changed at all)
950 names
(I don't know if this has changed at all)
What is the maximum number of roles in an access control list?75 Roles75 Roles
What is the maximum number of ACL groups a user can be member of?4096 5.0.9 up (pre-5.0.9, a bug may crash server over 3000 groups)4096
What is the maximum number of groups that can be nested?20 levels or up to 64k of group name and person name characters, whichever is lower (~30k of data using @UserNamesList or @UserRoles)
(in R4: 6 levels)
?20 levels or up to 64k of group name and person name characters, whichever is lower (~30k of data using @UserNamesList or @UserRoles)
What is the maximum size of a single paragraph you can cut or copy to the Clipboard?Unlimited (64K for UNIX)Unlimited (64K for UNIX)
What is the maximum number of documents you can cut or copy to the clipboard?2335 (Win32)2335 (Win32)
What is the maximum number of users to have authorized passwords on a multiple password ID?8 users8 users
What's the maximum amount of storage that can be used for strings in a LotusScript module?2 GB or available memory.2 GB or available memory.
What's the maximum length of an environment variable value?255 characters255 characters
What's the maximum length of a string constant in @function formulas?~2k characters~2k characters
What's the maximum number of results that can be returned from a full text search4,9994,999
What's the largest URL HTTP will accept?1024 (2048 5.0.10 up)2048 (?)
What's the largest richtext field HTTP will update?~64k?~64k?
What's the maximum size of variable-length strings in a LotusScript module?2 GB (1 GB of characters) per module, or available memory.2 GB (1 GB of characters) per module, or available memory.
How many variable-length strings can be defined in LotusScript?Limited by available memory and module definitions. Can be limited by symbol table to 64k of symbol names per module.Limited by available memory and module definitions. Can be limited by symbol table to 64k of symbol names per module.
What's the maximum size of fixed-length strings in LotusScript?64k (this is a BASIC language limitation)64k (this is a BASIC language limitation)
What's the maximum length of a string literal in LotusScript?32k (16k characters) (this is a BASIC language limitation)32k (16k characters) (this is a BASIC language limitation)
What's the maximum line length of a line written by LotusScript Write statement?255 characters255 characters
How many characters can be in path in MkDir, RmDir, or ChDir statement?128. This includes the drive specifier, if any.128. This includes the drive specifier, if any.
How many items can be in a Print, Write, or Input statement?255255
What's the maximum recLen in Open statement?3276732767
How many symbols can LotusScript handle?64k of text in symbol names64k of text in symbol names
How many data elements can be in a LotusScript array?Determined by memory available for data, and by the storage size of each element of the array, which varies with the array data type. For example, a Long one-dimensional fixed array declared in type scope can have 16,128 elements. (The total storage size available for fixed-size data in module scope is 64K bytes, and a Long element requires 4 bytes for storage.)Determined by memory available for data, and by the storage size of each element of the array, which varies with the array data type. For example, a Long one-dimensional fixed array declared in type scope can have 16,128 elements. (The total storage size available for fixed-size data in module scope is 64K bytes, and a Long element requires 4 bytes for storage.)
What's the maximum size of a LotusScript executable module's code?limited by available memory; 64k of source without LSS include fileslimited by available memory; 64k of source without LSS include files
How many outline entries can an outline have?~21,000 entries~21,000 entries
How long can a remote-console command be, and still display properly in Administrator?77 characters. Some commands may handle more; others don't. The command itself is neither displayed nor logged as more than 77 characters.Database 'Lotus Notes Knowledge Base', View '1) Knowledge Base\All Info - Flat Search View', Document 'Output to Remote Console and Log Truncated When Longer Than 77 Characters'More than 77 characters (documented as "addressed" in K-Base, but no new maximum value is documented). Database 'Lotus Notes Knowledge Base', View '1) Knowledge Base\All Info - Flat Search View', Document 'Output to Remote Console and Log Truncated When Longer Than 77 Characters'
Note Even though strings in LotusScript 4 (that's Notes and Domino 5) can be longer than 64K, there are still restrictions with the length of the string you can read or write using the GET and PUT statements. The only combination of filetypes that will work with long strings is with a binary file and a variable-length string. Fixed length strings, strings in variants, and random files will not work with strings greater than 64K in length because they have a two-byte header which contains the length of the string. Two bytes cannot represent more than 64K.