At 11:54 AM 7/10/2013, Stephen Markson wrote:
Does anyone know?
Is the memory used by a TEMPORARY table or view released when the
table/view is DROPped? If not, can that memory be released somehow
(without closing R:Baseor disconnecting)?
Thanks for your help.
Stephen,
If all routines are programmed and managed correctly, including the
R:BASE environment settings for "TMP" and "SCRATCH" folder having
the full read/write user privileges, there should be no concern
about releasing the used memory, etc., especially when managing
TEMPORARY tables, views, or even huge SORT (ORDER BY) clauses.
However, here's an "undocumented" PROPERTY command, introduced not
long ago for our corporate and government clients using R:BASE
eXtreme 9.5 to handle such situations, when deemed necessary.
-- Example
-- Undocumented Commands
-- Use it with caution (on demand)
PROPERTY APPLICATION FLUSHMEM 'TRUE'
RETURN
You may use the code as Custom EEP for Speed or Enhanced Speed
Button somewhere invisible on your application main menu with
Transparent and Flat properties of the control set to 'true'.
And, that is your undocumented tip of the day!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
