Fixed Asset - Picture display

Faulcon
Faulcon Member Posts: 19
edited 2004-11-10 in Navision Attain
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

Comments

  • kine
    kine Member Posts: 12,562
    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)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Polleke
    Polleke Member Posts: 18
    Why not make a hyperlink to a file on disk (that can only be viewed and not changed/deleted)?
  • RobertMo
    RobertMo Member Posts: 484
    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.
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

Categories