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/ -- 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.
