[LUNI] database question

[Martin Maney]

On Tue, Aug 06, 2002 at 06:49:17PM -0700, Richard Reina wrote:
> I have a document that coresponds to each record in a table in a MySQL 
> database.  In the future I am planning to image the each document ( 
> ussually 1 to 5 pages) and store them on my server.  Would it be best to 
> store them as a files in a directory or to or is their some data type 
> that can store them that I can add a colum in the table itself? 

Depends muchly on what you're going to do with them, as well as on the size
and number of images this will result in.  Offhand, I'd be inclined to
continue the existing document numbering scheme that ties the database to
the paperwork.  Unless your application demands a tighter coupling of the
data records and the docuemnt images?

Just tell us what you want to do.  :-)

-- 
During much of that epoch [the thirties and early forties],
I gained my livelihood writing for the silver screen,
an occupation which, like herding swine, makes the vocabulary pungent
but contributes little to one's prose style.  -- S J Perelman