[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Storage of Graphic files
From:       James Treworgy <jamie () trewtech ! com>
Date:       2000-05-31 16:26:46
[Download RAW message or body]

A subject of continuing debate, but if the application permits it I would 
generally advise keeping the graphics files outside SQL.  You will quickly 
diminsh performance by trying to keep a lot of big images inside your 
database.  A better solution - again if the situation permits - is to keep 
a thumbnail in the database and store a reference (perhaps a URL) to the 
full image.

Implementation details might include having your Access frontend convert an 
image to a thumbnail when someone adds one to the database (accomplishable 
with shareware image processing libraries/controls), store the thumbnail 
binary data, and copy the image to the file system storage area.

Jamie

At 08:56 AM 6/1/00 -0700, CURTIS David wrote:
>I wish to use Linux with MySQL to catalog information about images and 
>also to store the images.  Can MySQL do this?  Is that what MySQL BLOB 
>objects are for?  In Microsoft land I would use an OLE Object type to link 
>to the graphic file.   I was hoping to use NT Workstation, MySQL ODBC 
>drivers and MS Access 2000 to access the data.  Hey I'm a newbie and am 
>learning every day.  If you have any ideas, I would love to hear them.


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread39011@lists.mysql.com

To unsubscribe, send a message to:
    <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]