Friday, November 29, 2019
Tip of the Day: Database Performance Over Time
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.2.11111 or higher
Section.......: Tables, Commands
Keywords......: Performance, Database Design, Optimize
Have you checked your database today?
R:BASE database administrators are advised to revisit their database design
on a continual basis, 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 instances where modules are added to an application, major data shifts
have transpired, column definitions are added/modified, or other significant
changes take place, the table, column, and index definitions must 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 review 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 an optimization review at scheduled intervals also allows database
administrators to keep current on the latest commands, functions, and
techniques
available in new releases.
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/201911290512.xAT5C3jM147162%40jax4mhob24.registeredsite.com.
