Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154

    Unanswered: Whoa! 2GB database, 200 records?!?!

    Hi there - I have here a monstrosity of a database!! I developed this for a client to track her art collection. One table, one query, one form, two reports.

    All of the fields are text and number, except two which are memo and OLE object (for the photos!)

    Each of the photos is about 3.5MB. To insert the images, I have instructed her to right click on the "image" section of the form, choose "insert object", choose "create from file" and then browse to the folder with her pic and insert it.

    I left her with this about six months ago. It has now grown to about 250 records

    Man, this DB is 2 GIGS!! Needless to say, it performs pretty slow as well...

    Any suggestions on how I can temper this little sucker down and make it reasonable in size?

    Thanks, y'all, in advance for your thoughts...
    Last edited by jimmyswinger; 08-11-04 at 00:06.

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Its probably due to the ole objects and pictures within....

    This causes enormous bloating of databases... Try compacting it....

    If that dont help, try extracting the pictures to a folder and showing them "on the fly" instead of directly from the db...

    Hope this helps....

    Greetz

  3. #3
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154
    Thanks for your reply, namliam!

    I tried compacting it, it improved (shrank) by 100MB!

    I think I'll have to try showing the photos on the fly... I'll see what happens.

  4. #4
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    Access stores image data in bmp format. so even if you add jpg file, it converts it to bmp before storing. which ends up having a huge database files.
    ghozy.

  5. #5
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Yea my database for my company originally included small thumbnails. It quickly pushed my database to almost 100MB in about 300 records. I definitely would recommend just having a path and file name text box with which to produce the pictures as you need them. I makes for a much smaller database.

    I am about to remake the company database because of several reasons and that just being a small one but definitely one that I want to get away from.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Time to switch to a managed file system for the pics instead of imbedding them in the db.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Aug 2004
    Location
    Houston, TX
    Posts
    1

    Question How about this?

    Hi guys,
    My idea is, you can place JPG pictures in to a folder and place links from database to view them in internet explorer or any other quick viewer (just like irfanview acdsee). Not keeping them in the database!?

    I don't know how sounds like. Is it stupitly or good enough??

  8. #8
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    I witnessed some people using your way. only problem about it you have to click to a button each time to see the picture in explorer. managed file system lets you see the picture while moving through the records, which is sometimes important with most graphic databases for speed browsing.
    ghozy.

  9. #9
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    How does the managed file system work? I have never tried that. I have done what I said and put the path and file name inside 2 different fields. How different is the managed file system?

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  10. #10
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Smile File managing with pics

    I'm not too sure what is meant by the file managing system suggested above. I would definitely link to you pictures from the database and display them on a form in an image box. Any events to load the picture shoudl be on code in the on load event and any navigation buttons. I wouldn't let the user navigate through the pictures - you'll end up with them looking at one record and a picture from a different record.

  11. #11
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    I did the same thing OLE the picture Yeap it got big

    What I ending up doing is store the Filename in a Feild
    In the Form in the Current Event loaded the Filename in to a image frame

    me.pic = LoadPicture(Path&FileName)
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  12. #12
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    this is exactly what it means. you keep path and names in a table and manage loading and saving operations yourself instead of ole.
    ghozy.

  13. #13
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    another option is saving raw file into BLOB fields in access. It needs alot of work, but can be done.
    ghozy.

  14. #14
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154
    The user is totally novice and loves being able to preview the photos while browsing the records! That's the tough part. I screwed up by designing it this way in the first place.

    Well, it sounds like linking to the photos is a better way to go. I like Ryker and myle's suggestion,

    me.pic = LoadPicture(Path&FileName)

    that way she can still check out the photo without all the bloat.

    I was hoping to find an add-in that would allow me to open the form, fill in the data, then browse to the image and the add in would then thumbnail it and link to it!

    Thanks for all your responses! This forum rocks!

  15. #15
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    My database that holds our parts have them displayed in a 3d manner as much as is possible with a 2D picture. I plan on having a link where the person can click and rotate the 3D object to view all angles from the database.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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