Fixed Asset - Picture display

Faulcon

I have been asked to look at bringing pictures into the Fixed Asset - Picture field. Considering we have over 20000 fixed assets though, I'm concerned about what this might mean for the space taken by the database even if most remain empty. I was thinking of using a graphical converter to store the images as JPG and converting them to BMP at need to reduce the effect. Would this be worthwhile, and if so can someone suggest the best package/method to do so, or does Navision store these BMP files in such a way as to minimise the size and impact on performance?

We're also migrating to SQL Server and then 3.7 over the next month or two if that makes a difference to the answer.

Thanks

kine

Navision compress data stored into BLOB fields. How much I dont know. But I think, that if you want use this pictures in Navision, they must be in BMP format (or you must do conversion before using them). Compress image with JPG and than convert it into BMP have no effect, because BMP have still same size (width*height*BPP+header)

Polleke

Why not make a hyperlink to a file on disk (that can only be viewed and not changed/deleted)?

RobertMo

or publishing an asp site on intranet with url like:
http://ourintranet/showFA.asp?jpgname=00001

your asp page can construct a web page
using jpgname parm to construct <img src=?> tag.

This way you don't have a modify/delete of original problem.