Determining an Image size from an Ostendo Table

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 in KBs) from the ItemMaster.MobilityImage field for all items

select itemcode, OCTET_LENGTH(mobilityimage) as mobilityimagesize from itemmaster order by 2 desc

This SQL can be modified to show image sizes for other records. 


eg: This SQL shows image sizes in descending size (displayed in KBs) from Photos taken within Freeway

select ServiceID, OCTET_LENGTH(ImageBlob) as mobilityimagesize from servicesheetimages order by 2 desc

    • 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 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 ...

    • Manually Running a Database Sweep

      The default database sweep value is 20000. If this value has been amended to Zero, it will be necessary to empty out accumulated 'garbage'. This can be achieved by either performing a Firebird Validate / Backup and Restore of the database, or ...

    • Increasing Firebird Performance

      Below are links to two articles relating to potentially increasing Firebird Performance https://ib-aid.com/en/articles/how-to-make-firebird-work-20-faster-at-windows-server-2016-in-less-than-1-minute/ ...