Kbase P98806: In OpenEdge 10 can I have records of 1 Gigabyte in size?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/14/2004 |
|
Status: Unverified
GOAL:
In OpenEdge 10 can I have records of 1 Gigabyte in size?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
There is still a 32k size limit on records. And the "raw" datatype is exactly the same as in previous Progress Versions.
However, since Version OpenEdge 10 you can have table columns that are "large objects"--binary or character. These large objects are conceptually part of the record, but are stored separately. The lob (Large Object Binary) column in the record contains a "lob locator" that points to the pieces of the large object. We did this so that fetching a record when you are not interested in the contents of the large objects does not incur the overhead of retrieving them. They are retrieved as needed when you manipulate them in the 4GL.
Large objects can be up to 1 GB in size. They are not indexable.
Operations on lobs, like anything else in the database, use the transaction logs so in Version OpenEdge 10 there is transaction log overhead for creating, updating, and deleting them.
There is also a "longchar" datatype in the 4gl, which works much like the char datatype, except that longchar variables not bound by the 32k record size limit.