I have a question on this document. If you're running a compiled app, is there a property to set this "slave table display" off? Or is it a moot point because there is no "database explorer" when running RBase thru a compiler?
If you have a bunch of workstations on a network running a full RBase install, would you have to change each workstation's individual setting? Or, again, is there a property I can invoke in my startup program? Thanks! Karen -----Original Message----- From: A. Razzak Memon <[email protected]> To: rbase-l <[email protected]> Sent: Fri, Jan 27, 2017 8:05 am Subject: [RBASE-L] - Tip of the Day: Speeding Up the CONNECT Time Friday, January 27, 2017 Tip of the Day: Speeding Up the CONNECT Time Product.......: R:BASE X/X Enterprise (Version 10) Build.........: 10.0.2.20127 or higher Section.......: CONNECT Command and Database Explorer Keywords......: CONNECT, DB Explorer, Forms, Reports, Labels Among so many cool features and built-in development tools in R:BASE X and R:BASE Enterprise (Version 10) is the powerful and information-rich Database Explorer that displays very useful information for each section as follows: . Tables (Name, Comment, Columns, Rows, Date/Time) . Views (Name, Comment, Columns, Date/Time) . Stored Procedures (Name, Comment, Size (bytes), Date/Time, Version) . Forms (Name, Form Table(s), Comment, Size (bytes), Date/Time, Version) . Reports (Name, Report Table(s), Comment, Size (bytes), Date/Time, Version) . Labels (Name, Main Table, Comment, Size (bytes), Date/Time, Version) . External Forms (Name, Comment, Size (bytes), Date/Time, Version) . Applications (Name, Date/Time, Size (bytes)) . Command Files (Name, Extension, Date/Time, Size (bytes)) As you can see, the moment you CONNECT the database, all database related Database Explorer sections MUST be populated with all relevant columns, not the mention the expanded read and extraction of all forms and reports with Master as well as Slave table(s)/view(s), etc. Now imagine the connection time to one of my simple database with 145 tables, 81 Views, 667 Forms (not a typo), 247 Reports. And to read many Forms with Master/Slave Tables/Views and Reports with Sub-Reports (Master/Slave Tables/Views). So, obviously, it will certainly take a little longer for R:BASE X and R:BASE X Enterprise (Version 10) to CONNECT the database and to read the database tables, forms, and reports to populate all sections of Database Explorer, not to mention the parsing of all forms and reports with Master/Slave tables/views. There was no such feature in R:BASE eXtreme 9.5 to display Master/Slave Tables/View for Forms and Reports section of Database Explorer. That should explain the technical reason of the little extra time it takes when CONNECTing the database. Timing may vary when connecting the database being shared in a multi-user LAN, WAN, and Cloud environments. Having explained that ... Did you know that you can expedite the CONNECTion time by simply disabling the option to [ ] Show Slave Tables? Here's how ... Main Menu > Settings > Database Explorer > Show Slave Tables Enabling/Disabling the Show Slave Tables option will show/hide slave tables for forms and reports. Now that you know, make the appropriate changes to your default settings as you see fit. And, don't forget to have fun! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 34 years of continuous innovation! 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
