Razzak, Could you give us a description of what FLUSHMEM does? That would help us in determining if it will help us and what cautions we should consider.
Thanks Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, July 10, 2013 11:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: releasing memory 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! --
