Memory Resident Tables

Registered by Paul McCullagh on 2008-10-13

PBXT memory resident tables (MRT) have no files on disk, and are not durable. The table is held entirely in memory. Since PBXT already caches index, handle data and row pointer files, in cache, the implementation only requires a solution for the data log file data.

It would be possible to limit the amount of RAM use by an MRT. When the RAM threshold is exceeded, the MRT is written to standard PBXT table files.

The implementation would require a new table attribute, for example: CREATE TABLE t1 ( ... ) TABLE_TYPE=IN_MEMORY;

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
Paul McCullagh
Definition:
Approved
Series goal:
None
Implementation:
Implemented
Milestone target:
None
Started by
Paul McCullagh on 2009-09-15
Completed by
Paul McCullagh on 2009-09-15

Whiteboard

This feature has been implemented in PBXT 1.1

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.