R:azzak, Thanks for the explanation. I will be implementing these commands today as I believe might help with some ongoing issues I have. Is there a performance penalty associated with the FLUSMEM command, either by not having some data in memory or in the time it takes to execute the command? Is there a reason why I couldn't or shouldn't use this command liberally though out the application? Thanks in advance for your help.
Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, November 07, 2013 1:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: compiled apps best practice At 12:59 AM 11/7/2013, Javier Valencia wrote: >Thanks R:azzak, >I took it for a drive and looks good. I have a couple of questions, why >do you have the these two commands? > >SET UINOTIF OFF >What is the purpose of this command? Is it used only for performance? > >PROPERTY APPLICATION FLUSHMEM 'TRUE' >Where is the best way to place this command and how often can it be used? >Is there a performance penalty using it often and at different places >in a compiled application? Javier, The sample application is designed and intended to illustrate the use of R:BASE External Form File (.rff) to manage the entire application flow in a multi-user environment, especially when using the R:Compiler 9.5. To answer your questions ... Technically, "SET UINOTIF OFF/ON" controls the automatic user interface notifications/updates for Database Explorer to refresh the list and al details regarding Tables, Views, Stored Procedures, Forms, Reports, Labels, External Forms, Applications, and Command Files. In a typical R:Compiled application environment when there is no Database Explorer, no RBDefine, and no Form/Label/Report Designers, the use of "SET UINOTIF OFF" disables all callbacks that are constantly being sent to front-end when any updates are performed to refresh the DB Explorer. Thus, a MAJOR improvement in performance. The on-demand use of CONNect and DISConnect database(s) is also fast in such environment. Depending on your application, you will have to find the best place to use the PROPERTY APPLICATION FLUSHMEM 'TRUE' command. Typically, after manipulating large BLOB data, heavy SORT by very large Reports, creating and saving heavy duty PDF reports with Rich Text and BLOB data, Forms, and Custom Plugins would be the perfect place to use the "FLUSHMEM" command. Using the "FLUSHMEM" right after SDETACHing and SDISCONNECTing foreign database(s) is also a perfect spot. Implemented a long time ago (as undocumented commands), these special SETtings and PROPERTY commands are a result of designing and deploying very complex applications for our Government & Corporate clients using R:BASE eXtreme 9.5 (64) along with custom R:BASE Interfaces & Plugins. Have fun and make sure to explore all details in that sample application! 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! --
