Difference between revisions of "System Capacities"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
==Fields and Variables== | ==Fields and Variables== | ||
Line 23: | Line 20: | ||
|- | |- | ||
|valign="top"|Maximum memo/object file size||valign="top"|2^64 bytes | |valign="top"|Maximum memo/object file size||valign="top"|2^64 bytes | ||
+ | |- | ||
+ | |valign="top"|Maximum single memo/object size||valign="top"|100MB | ||
|- | |- | ||
|valign="top"|Maximum index file size||valign="top"|2^64 bytes | |valign="top"|Maximum index file size||valign="top"|2^64 bytes |
Revision as of 05:29, 12 July 2016
Contents
Fields and Variables
Feature | Capacity |
---|---|
Maximum character variable size | 64 KB |
Tables and Indexes
Feature | Capacity |
---|---|
Maximum table size | 2^64 bytes |
Maximum number of columns in a table | 256 |
Maximum memo/object file size | 2^64 bytes |
Maximum single memo/object size | 100MB |
Maximum index file size | 2^64 bytes |
Maximum index key length | 192 characters (index keys have an 8 character unique value postfixed, giving 200 characters in total). |
Maximum tag indexes in a multiple index file | 128 |
Identifiers
Feature | Capacity |
---|---|
Maximum procedure name length | 32 characters |
Maximum variable name length | 32 characters |
Maximum field name length | 32 characters |
Maximum index tag name length | 32 characters |
Programs, Procedures and Commands
Feature | Capacity |
---|---|
Maximum Lianja/VFP command length | 16 KB |
Maximum SQL SELECT statement length | 16 KB |
Others
Feature | Capacity |
---|---|
Sortable column in Grid Section | Sorted on first 192 characters |