Wednesday, May 17, 2017 Tip of the Day: Database Performance Over Time Product.......: R:BASE X/X Enterprise (Version 10) Build.........: 10.0.2.20411 or higher Section.......: Tables, Commands Keywords......: Performance, Database Design, Optimize
Have you checked your database today? R:BASE users, developers, and even so-called "R:BASE developers" are advised to continuously revisit their database design, as the performance can decline over time without optimization checks. It is expected that a database will grow, and so should the inherent design. Any time where modules are added to an application, major data shifts have transpired, column definitions are added/modified, or other significant change takes place, the table, column, and index definitions should be reviewed to maintain database integrity. The optimization checks may also find prior database and application changes that were overlooked, which are now more prominently in need of attention. The same checks should also be performed prior to moving an application from single-user to multi-user access. The following technical documents cover areas for database optimization: . Indexing Explained . Optimizing Application Performance . Understanding Referential Data Integrity in R:BASE . Multi-User Guide . Understanding WHILE Loop Optimization . Optimizing R:BASE Cloud Applications From The Edge: http://www.razzak.com/fte/ Performing optimization at scheduled intervals also allows users to keep current on the latest techniques, commands, and functions available in new releases. 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.
