Speeding up a Database with graphics files

[Mike-palmer]

I have created a DVD database that includes graphics files of the DVD case covers. Each cover is about 300K in size. The databse performed well when I only had 50 DVDs, but now I'm up to 200 DVDs and flipping through the database is getting slower and slower as it pulls up each record. The DB is about 70MB in size.

Currently all the DVD data (including the graphics) is in one table with other tables being used only for ratings.

Sometimes flipping from one record to the next happens quickly, but, especially across the network, it takes several seconds to go from one record to the next.

Are there any best practises that I should be following under these circumstances?

 

[Philem]

Generally it's not considered a good idea to have the graphics stored directly in Access. A common solution is to simply have a link to the graphic location stored in the database. A bit of code to enable clicking the link to see the graphic, or pull the graphic in a floating window, and you should be set.

HTH.

P

 

[Kevin_S]

Hi Mike,

Philem is correct in that, due to the size of OLE objects and the fact that Access has to store a lot of information about the object when it is embedded (reference data that helps the program render that picture correctly) they tend to "bloat" the size of the db - as you have witnessed - and as a result slow the performance.

A better alternative is to store all of the images in a common, accessible folder and then link the path of the image in the db. Then use an unbound object control to retrieve the image when called. I have attached a sample in access '97 that shows a perfect example of this process. Open the form "frmInventory" and click the new picture cmd button. This will open the windows explorer window and allow you to link a new picture. Also has a nifty reporting feature.

I do not pretend to take credit for the sample as I think it was provided by OldSoftBoss or perhaps someone else who regularly posts on this forum.

Good Luck!

 

[Mike-palmer]

Many thanks guys, this works much, much bettert. I have just one question ...

While flipping through the database when it's loading the picture for each DVD a msg box pops up saying that the picture is being imported. This is a not a big deal, but it's a bit distracting. Is there anyway to get rid of this pop-up?

 

[Tim K.]

Check this Hide "Loading Image" Pop-Up! out.

 

[Mike-palmer]

Thanks Tim, the registry entry worked like a champ.