Hi Razzak Would this free up the memory for this particular users session only Please advise more detail Thanks
Mohammed Sattar Utah Group of Companies Dhaka, Bangladesh -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, July 10, 2013 10:55 PM 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! --
