Difference between revisions of "System Capacities"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Barrymavin (Talk | contribs) (→Tables and Indexes) |
||
| (10 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Fields and Variables== | ==Fields and Variables== | ||
| Line 19: | Line 16: | ||
|- | |- | ||
|valign="top"|Maximum table size||valign="top"|2^64 bytes | |valign="top"|Maximum table size||valign="top"|2^64 bytes | ||
| + | |- | ||
| + | |valign="top"|Maximum records per table||valign="top"|2,147,483,647 | ||
|- | |- | ||
|valign="top"|Maximum number of columns in a table||valign="top"|256 | |valign="top"|Maximum number of columns in a table||valign="top"|256 | ||
|- | |- | ||
|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"|100 MB | ||
|- | |- | ||
|valign="top"|Maximum index file size||valign="top"|2^64 bytes | |valign="top"|Maximum index file size||valign="top"|2^64 bytes | ||
|- | |- | ||
|valign="top"|Maximum index key length||valign="top"|192 characters (index keys have an 8 character unique value postfixed, giving 200 characters in total). | |valign="top"|Maximum index key length||valign="top"|192 characters (index keys have an 8 character unique value postfixed, giving 200 characters in total). | ||
| + | |- | ||
| + | |valign="top"|Maximum tag indexes in a multiple index file||valign="top"|128 | ||
| + | |- | ||
| + | |valign="top"|Maximum cursors/workareas||valign="top"|255 (256 if no database is open, otherwise workarea 256 is reserved for the database). | ||
|- | |- | ||
|} | |} | ||
| Line 38: | Line 43: | ||
|- | |- | ||
|valign="top"|Maximum variable name length||valign="top"|32 characters | |valign="top"|Maximum variable name length||valign="top"|32 characters | ||
| + | |- | ||
| + | |valign="top"|Maximum field name length||valign="top"|32 characters | ||
| + | |- | ||
| + | |valign="top"|Maximum index tag name length||valign="top"|32 characters | ||
|- | |- | ||
|} | |} | ||
| Line 48: | Line 57: | ||
|valign="top"|Maximum Lianja/VFP command length||valign="top"|16 KB | |valign="top"|Maximum Lianja/VFP command length||valign="top"|16 KB | ||
|- | |- | ||
| − | |valign="top"|Maximum SQL SELECT statement length||valign="top"| | + | |valign="top"|Maximum SQL SELECT statement length||valign="top"|16 KB |
|- | |- | ||
|} | |} | ||
| Line 57: | Line 66: | ||
!width="35%"|Feature||Capacity | !width="35%"|Feature||Capacity | ||
|- | |- | ||
| − | |valign="top"| | + | |valign="top"|Sortable column in Grid Section||valign="top"|Sorted on first 192 characters |
|- | |- | ||
|valign="top"| ||valign="top"| | |valign="top"| ||valign="top"| | ||
| Line 64: | Line 73: | ||
[[Category:Lianja Scripting Essentials]] | [[Category:Lianja Scripting Essentials]] | ||
| + | [[Category:Documentation]] | ||
| + | [[Category:Reference]] | ||
Latest revision as of 22:10, 2 January 2023
Contents
Fields and Variables
| Feature | Capacity |
|---|---|
| Maximum character variable size | 64 KB |
Tables and Indexes
| Feature | Capacity |
|---|---|
| Maximum table size | 2^64 bytes |
| Maximum records per table | 2,147,483,647 |
| Maximum number of columns in a table | 256 |
| Maximum memo/object file size | 2^64 bytes |
| Maximum single memo/object size | 100 MB |
| 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 |
| Maximum cursors/workareas | 255 (256 if no database is open, otherwise workarea 256 is reserved for the database). |
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 |
