Queries on Bundle Info Select

[#1]

Hi,

I have loaded images from database to QVW through Bundle info select.

Since it is having huge data, it is taking long time to reload and save.

Could You suggest any method to overcome this.

Warm Regards,

Joshmi

[Gysbert_Wassenaar]

Load smaller images. Use a graphics tool to down scale the images to a smaller size and perhaps to a better compressible format too.

[#3]

Hi Gysbert,

Thank You for Your Reply...

Since we are having read only access to database, We can't edit or compress the image.

Is there any method for re sizing the image after reloading to qvw?

Regards,

Joshmi

[Gysbert_Wassenaar]

No. Once the binary blobs are in the Qlikview document they cannot be edited.

[stigchel · Accepted solution]

Not after loading, but maybe you can try to load them with the following statement

Image_size

This clause is used with the Info prefix to resize images from a database management system to fit in the fields. Width and height are specified in pixels.

Example:

Info Image_size(122,122)Select ID, Photo From infotable;