Fog Creek Software
Discussion Board




Knowledge Base
Documentation
Terry's Tips
Darren's Tips

Image Storage Duplication ??

If I've stored an image in the 'Images' folder and then drop it onto an Article body is the image being stored twice or is CD using a reference to the image in the Article rather than repeating the data in two database fields.

Perpetual Newbie II
Sunday, June 06, 2004

It's using a reference. If you look at the generated XHTML then you will see an <img> tag with the "src" attribute pointing to your image.

John Topley (www.johntopley.com)
Monday, June 07, 2004

I guess PNII tries to say. How is it stored inside the access database. As a reference or as a duplicate.

PeterM
Monday, June 07, 2004

Yea, sorry for not being clearer on that. I've had a peek in the database. I see where the images and articles are stored but both use OLE_BLOB (as far as I can tell) fields ~ doesn't tell me anything.
If I drop an image into an article is the image itself also stored in the article BLOB field?
If I put a reference to an image, using the magic name into an article ~ am I just adding a reference to the article BLOB field?
IF you add 10 BIG images in your project but drop them into 1,000 pages - how does that affect your project size? Does it reduce the issue if you use Magic Names?

Thanx
PNII

Perpetual Newbie II
Monday, June 07, 2004

My guess is, someone from the CD team will have to provide the information I'm looking for ~ next time one passes through :)

Perpetual Newbie II
Monday, June 07, 2004

Couldn't you just try this out? You can tell by going into properties to see whether the size of the database actually increased by adding the image to the article...

Rogn

Rognvaldr
Monday, June 07, 2004

Yes, well maybe, if your sure the file size increases are due to images being dropped into articles and not Access increasing file size in massive gulps to accommodate it's own perceived needs.

I thought it was a simple question that would get a relatively quick response either from the CD gurus that normally hang about here - or from a member of the CD team.

Does an image dropped on an article get stored with (duplicated in) the article as well? If I use a magic name do I avoid this?

I'm in no specific hurry.
PNII

Perpetual Newbie II
Monday, June 07, 2004

FWIW; I'm leaning toward 'drop the image or use the magic name - makes no difference it's all the same' BUT I didn't write CD and I can't lean on that supposition with any weight and not expect that there's a chance I'm gonna end up on my arse.

Perpetual Newbie II
Monday, June 07, 2004

Very simple to find out in view of the fact that no-one [so far] from FC is providing you with a definitive response.

When you do a copy/past or drag/drop of an image directly into an article does the image appear in the CD root assuming that you do not have a folder named pictures or img or images..

If you cannot find the image in the CD folder structure then that image is part of the BLOB. And BOLBS can get very large. If its a small site thats OK, but if a site is going to have many pages and many pictures IMO that is an extremely inefficient way to do it.

The way that I do it is;

I drop/drag all images I want to use into a image folder and then I use Insert Picture or magic name because I found that was the most efficient way to do it.

David Mozer
Monday, June 07, 2004

Crap.

Personal Reminder:
Put mind in gear BEFORE releasing mouth clutch.

IIRC:
The CityDesk article is stored in HTML format. The 'viewer' renders what is stored in the article ergo CD stores a reference to the image. Drop an image onto the viewer, switch to HTML view ~ <img src="PTMF00001213.gif" />

<sigh> that was fun :(

sorry all, that was embarrassing.
PNII

Perpetual Newbie II
Monday, June 07, 2004

Isn't that what I said? ;-)

John Topley (www.johntopley.com)
Wednesday, June 09, 2004

John,

Rereading your post with 'The CityDesk article is stored in HTML format.' in mind ... yes, exactly.
:)
PNII

Perpetual Newbie II
Wednesday, June 09, 2004

*  Recent Topics

*  Fog Creek Home