Determining Record Count and Table Sizes
When attempting to determine current database size it is useful to know each tables record count along with its size in MBs
This assists with determining whether there are specific tables causing a database to dramatically increase in size.
This script can be used as an analysis tool to determine what each table and view is storing and its approximate physical size in MBs.
This script will output a Text file that can be opened from within Excel and then reformatted to sort in descending sequence (eg: by MBs)
Related Articles
Data Volumes and Impact on Performance
Data Volumes This article explains how data volumes can influence performance and user experience. Apart from technical Firebird Database settings, Configuration settings within Ostendo can also affect performance. As sites run Ostendo and Freeway ...
Determining an Image size from an Ostendo Table
Sometimes there is a need to determine an image size from an image field within an Ostendo table. This can be useful to determine how image sizes have increased the size of a table. This SQL displays the image sizes in descending sequence (displayed ...
Database Sweep Interval Setting To Improve Performance
Amending the Database Sweep Interval Setting Overview: On some large databases, performance issues maybe experienced due to the database Sweep Interval setting being set at a higher level than need be. By default the Sweep Interval setting is set to ...
Audit Logging
File->System Configuration->Audit Logging If Audit Logging is employed, you should remember that this will create records in the AUDITLOGGING Table Current records can be displayed via General->Inquiries->Inquiry - Audit Logging Audit Logging allows ...
Screen Logging
File->System Settings->Environment Settings (tab)->Activate Screen Logging Ostendo allows you to trap user activity and habits enabling you to design Workflows and other tools to assist users in areas they are repetitively accessing within Ostendo. ...