Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Minimise database size with images (XP)

    Has anyone any suggestions on how to minimise database size when you include graphics in reports <img src=/S/question.gif border=0 alt=question width=15 height=15>
    - I've been asked to put company logo, product logo and a couple of other images on the reports, and the mdb size is starting to shot up <img src=/S/frown.gif border=0 alt=frown width=15 height=15>
    I want to try and keep it to a minimum as a lot of our people have to download the files, when they are on the road in hotels using at best 56k modems, so adding on Mbytes is not going to make me popular <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    One thought I'd had was adding a sub-report for each logo to the main report, would that actually save space <img src=/S/question.gif border=0 alt=question width=15 height=15>

    Another thought <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15>, I wonder if this is why my checkin/out of Visual SourceSafe has been taking longer <img src=/S/help.gif border=0 alt=help width=23 height=15>
    - I suppose the images must be in there somewhere, presume in a "text" encoded format

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Minimise database size with images (XP)

    I was going to suggest making the images linked instead of embedded, but that won't work if people have to download the database, unless you can install the image files in exactly the same location (path) on the laptops.

    Putting the images in one or more subreports should help, since there will be only one copy of each image, instead of a separate copy in each report.

    You might also look into optimizing the images - if you have a 800 x 600 pixel logo that is displayed as 80 x 60, the 800 x 600 image is stored in the database. You can use a graphics program (I use IrfanView, but there are others) to resize the image to the display size.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimise database size with images (XP)

    To help minimise download time show your users how to use programs such as winzip and have it as a zip file. That can often reduce an mdb to 20-30% of it's unpacked size I find.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimise database size with images (XP)

    Thanks for the suggestion, but the files are already zipped at max(slow) compression setting <img src=/S/frown.gif border=0 alt=frown width=15 height=15>

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimise database size with images (XP)

    Hans, thanks for the response
    Nope, I can't guarantee where they'll put them on their laptops <img src=/S/frown.gif border=0 alt=frown width=15 height=15>
    It's good to know that the one sub-report means only one copy. I'll also check out what can be done with reducing the actual images

    Another thought I'd had was on what format of image to include <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15>
    - is say JPEG better than GIF or PNG <img src=/S/question.gif border=0 alt=question width=15 height=15>
    I'm assuming that Access "processes" the image in someway, so is one format better than another <img src=/S/help.gif border=0 alt=help width=23 height=15>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Minimise database size with images (XP)

    The problem with storing images in an Access database is that whatever the image format, Access also stores an uncompressed bitmap image (presumably to speed up displaying it). So you might as well use .bmp's.
    I did a small test - created a .bmp, size 33 KB, and converted it to a .png, size 3 KB.
    Created an Access 97 database with one empty form. Size of database (after compacting) 66 KB.
    Created an Access 97 database with one form with an image control on it, loaded the .bmp into the image control (embedded). Size of database (after compacting) 100 KB. Seems reasonable: 66 + 33 + a bit of overhead = 100.
    Created another Access 97 database, also with one form with an image control, loaded the .png into the control (embedded). Size of database (after compacting) 130 KB. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Minimise database size with images (XP)

    Graphics do affect the checkout time in VSS. If you view the object in VSS, you'll see a huge piece of the object is the text rendering of the graphics.
    Charlotte

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimise database size with images (XP)

    <img src=/S/woops.gif border=0 alt=woops width=58 height=36> Thanks Charlotte, just looked in my .scc folders and compared some of the ACR files, yeap with image about 600 Kb, without about 15 Kb.
    I presume if I go along the route of using a single sub-report in each main report, it should help, as the main report will only have a sub-report control on it <img src=/S/question.gif border=0 alt=question width=15 height=15>

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimise database size with images (XP)

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> interesting <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Thanks, that's really interesting Hans, especially the more compact PNG creating a bigger MDB
    - guess who got all his images in PNG format <img src=/S/frown.gif border=0 alt=frown width=15 height=15>

  10. #10
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimise database size with images (XP)

    Does Zipping a file really decrease the download time? I always thought that modems copressed on the fly so that download times would be similar.

    Peter

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Minimise database size with images (XP)

    You're talking about two different kinds of compression, hardware (the modem) and software (winzip). Hardware compression is something that can be affected by all sorts of things. If you provide a compressed file in the first place, you eliminate some of the possible performance variations.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •