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

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

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

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

    • Improving Performance of Opening Lists

      As a database gets larger, the opening List grids can take longer to load, when 'Include Closed' Orders, 'Include Updated Status' or 'Include Fully Paid' is turned on along with Filtering and Sorting from the Grid options. This is because in order to ...

    • Firebird Restart to improve performance and remove External Users

      Firebird Stop / Start process Large Ostendo sites running 20+ users should stop and re-start Firebird on a regular basis to ensure performance is maintained. The major issue to automating this process in the past has been the worry that users may ...