[dba-SQLServer] Graphics in SQL Server table

Mark Breen mark.breen at gmail.com
Tue Nov 30 17:15:57 CST 2004


Hello Steve,

Now that is interesting, but what I would really be interested in for
a potential future project is (and I know this is a solution trying to
find a problem), what do you think of storing a whole lots of PDF's in
SQL?

Of course I can store them in the file system, but I am going to have
to build a system that will track and print PDF's, your email has made
me wonder whether there is any benefit in attempting to keep them in
the db.

One thing that I will have to do in have a sort of in-form PDF viewer.

Again, there is no need to store them in the db, but I just thought it
might be an idea.

Any thoughts?  Are you glad that you stored your gig's in the db, did
you reap any benefit?

Thanks

Mark



On Tue, 30 Nov 2004 13:05:04 -0600, Steven W. Erbach <serbach at new.rr.com> wrote:
> Dear Group,
> 
> Even though the standard advice for storing graphics on a web server is to store them in the file system, I've decided to store graphics in tables. I've used the ADO Stream object to read GIFs from disk and write them into an Image field.
> 
> I found that the original images (over 4,000 GIFs) averaged 53.6KB each. When they've been written into the SQL Server tables the amount of table "space" allocated for each image stored averages 63.2KB. So there's about 10K of "overhead" (about 18%) for each image. Not bad.
> 
> Getting the images out of the original Access database was a bit of a chore, though. Fortunately IrfanView allows command line options to paste an image into the window and convert the image to a GIF. I was able to cycle through all the images in relatively short order by copying to the Windows clipboard and pasting and saving with IrfanView.
> 
> Steve Erbach
> Neenah, WI
> 
> sweblog1.blogspot.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>



More information about the dba-SQLServer mailing list