Way cool, in-memory views, as in-memory tables have proven to be.
Thank you, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "The Support Team" <[email protected]>
To "[email protected]" <[email protected]>
Date 11/20/2025 4:42:43 AM
Subject [RBASE-L] - Tip of the Day: Added Support for In-Memory Views
Thursday, November 20, 2025
Tip of the Day: Added Support for In-Memory Views
Product: R:BASE 11
Build: 11.0.3.11120 or higher
Section: General
Keywords: Views, In-memory, Temporary, Temp
R:BASE 11 now supports in-memory views, allowing temporary views to be
stored directly in memory rather than in temporary files. This
enhancement provides faster processing and more efficient use of
temporary data structures.
Creating In-Memory Views
You can define an in-memory view using the INMEMORY keyword in the
CREATE VIEW command or by selecting the appropriate option within the
R:BASE menu system when creating or copying views.
Example:
CREATE INMEMORY VIEW CustomerContact +
(CustID, Company, ContID, ContFName, ContLName, +
ContPhone, ContEMail, LastContactDate) +
AS SELECT T1.CustID, T1.Company, T2.ContID, T2.ContFName, T2.ContLName,
+
T2.ContPhone, T2.ContEMail, T2.LastContactDate +
FROM Customer T1, Contact T2 +
WHERE T1.CustID = T2.CustID
View Identification and Management
The LIST command displays in-memory views with an (I) indicator instead
of a (T) indicator.
LIST VIEW <ViewName> provides detailed view information and labels the
view as In Memory Temporary, consistent with in-memory tables.
The UNLOAD command includes the INMEMORY keyword when unloading the
definition of an in-memory view.
Expanded In-Memory Table Limit
In addition to in-memory view support in R:BASE 11, the maximum number
of in-memory tables per database has been increased from 25 to 1000,
significantly expanding capacity for performance-sensitive operations.
Updated Technical Documentation
Due to extensive changes in the behavior of temporary tables and views,
the From The Edge technical document, “Understanding Real, Temporary,
and In-Memory Tables and Views,” has been thoroughly revised.
From The Edge:
https://www.razzak.com/fte/
Topics include:
. Creating Temporary Tables/Views
. Advantages of Temporary Tables/Views
. File-based Temporary Tables/Views
. In-memory Temporary Tables/Views
. Differentiate Table/View Types
. How Tables and Views are Stored
. When to Use What Table/View Type
. Using Forms, Labels, and Reports with Temporary Tables/Views
. Removing Temporary Tables/Views
The Support Team
R:BASE Technologies, Inc.
https://www.rbase.com <https://www.rbase.com/>
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1946905117.490073.1763642563259%40mailbusiness.ionos.com
<https://groups.google.com/d/msgid/rbase-l/1946905117.490073.1763642563259%40mailbusiness.ionos.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/em6f841749-415a-4156-b54d-23f4a38c45bd%40058e6b7c.com.
