Tim,
I did this for a large collection of images, ~1million images up
around 40 gigs total last time I checked (no longer involved in the
project). It worked very well, performance was not horrible compared
to file-based storage. I always feared that MyISAM table getting
corrupted and having to run a myisamcheck. The backup was a bit
tricky too, had to have the data replicated elsewhere because it took
over an hour to backup and we couldn't have the table locked up that
long on production.
There was a good discussion about this on this weblog recently:
http://sheeri.com/archives/39
No experience with document mangement system. We talked a few times
about working with a digital library for storage but were never
compelled to go beyond what we had in MySQL.
Mike
On Apr 18, 2006, at 9:48 PM, Tim Lucia wrote:
Hi all,
I am considering moving some archival records which largely consist
of blobs
(PDF Image files) out of an Oracle DB and onto MySQL. Has anyone
done this
(not necessarily the Oracle part) who can relate their experience
(s)? I can
go with MyISAM or archive storage engine, from the looks of it.
This is not
transactional data, although eventually some reporting may be required
(although since the blob data are things like fax archival
documents, I'm
not sure what can be reported.)
Another possible storage model would be to use MySQL as the index
but put
the blobs (.PDFs) into some document management system. If you've
done
anything like this, I'd like to hear about it as well.
All input appreciated (to the list, please ;-) )
Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]