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 ...
Database Sweep Interval Setting To Improve Performance
Overview: Garbage Collection: This is the ongoing cleaning of the database and is performed in the background around the clock. This constantly reorganises the memory space used by the database. If you don't clean up the database performance will ...
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 ...
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. ...