Thanks for that, Razzak! Regards,
Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: July-10-13 12: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! --
