Database and index space usage (Audio – Video – Images – Text )

Build 1501 on 14/Nov/2017  This topic last edited on: 19/Sep/2015, at 15:51

Original audio, video and images are saved into a volume (file system). Video preview can be saved either in the database or in the file system depending on schema configuration.

Video and Images

The thumbnail and the preview for images and video are saved into the database.

The space occupation for such previews is about (samples):

Jpeg thumbnail 80x80 – quality 80% ~2K

Jpeg preview 300x300 – quality 80% ~30K

Jpeg preview 300x300 – quality 100% ~90K

For each element a thumbnail and a preview is created into the DB. The preview can have different quality and depending on the choosen quality the space used may vary.

The index occupation is very low because only few information about the audio, video and images are indexed. Normally few KB each.

One thing to consider is if there is a script attached to audio/video. This will definitively increase the amount of data that goes into the index.To calculate the script size consider that 1 minute of speach is about 1KB.

Text

The text objects go entirely into the database. The space occupied in the index is about the 30% of the original text.