What is High Speed Tables? Diff between normal file and High speed tables?
Page 1 of 1
What is High Speed Tables? Diff between normal file and High speed tables?
What?
A high speed table is not a "thing" in itself. A high speed table is a normal LANSA file definition that has its "high speed" flag set to YES.
• A LANSA file definition flagged as high speed table is actually implemented as a normal database file. All functions which insert, update or delete data in the table actually access the normal database file.
Diff between normal file and High speed tables
This normal database file actually contains the data, so there is no difference in the risk of data loss between a normal file definition and a high speed table.
This also means that you can, at any time, set the high speed table flag back to NO and revert to a normal database file again without any loss of definition or data.
The difference between a normal file and a high speed table is that a high speed table uses an extra object (over and above the normal database file). This object is called an OS/400 "User Index" and it contains a duplication or "mirror" of the data in the associated database file and its logical views.
A high speed table is not a "thing" in itself. A high speed table is a normal LANSA file definition that has its "high speed" flag set to YES.
• A LANSA file definition flagged as high speed table is actually implemented as a normal database file. All functions which insert, update or delete data in the table actually access the normal database file.
Diff between normal file and High speed tables
This normal database file actually contains the data, so there is no difference in the risk of data loss between a normal file definition and a high speed table.
This also means that you can, at any time, set the high speed table flag back to NO and revert to a normal database file again without any loss of definition or data.
The difference between a normal file and a high speed table is that a high speed table uses an extra object (over and above the normal database file). This object is called an OS/400 "User Index" and it contains a duplication or "mirror" of the data in the associated database file and its logical views.
Similar topics
» What? A high speed table is not a "thing" in itself. A high speed table is a normal LANSA file definition that has its "high speed" flag set to YES. • A LANSA file definition flagged as high speed table is actually implemented as a normal database file.
» Direct control of system names for tables, views and indexes
» Explain the difference between normal AS/400 file definition and Lansa file Definition?
» What are the reasons a logical file may be "dropped" during the File definition load process?
» Define term 'File Type' and list various file types.
» Direct control of system names for tables, views and indexes
» Explain the difference between normal AS/400 file definition and Lansa file Definition?
» What are the reasons a logical file may be "dropped" during the File definition load process?
» Define term 'File Type' and list various file types.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum