RE: Document / Image (Blob) archival -- Best Practices

2006-04-20 Thread Tim Lucia
- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 11:35 PM To: Tim Lucia Cc: mysql@lists.mysql.com Subject: Re: Document / Image (Blob) archival -- Best Practices Tim Lucia wrote: > Hi all, > > > I am considering moving some archival records which largely c

Re: Document / Image (Blob) archival -- Best Practices

2006-04-18 Thread Daniel Kasak
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 engin

Re: Document / Image (Blob) archival -- Best Practices

2006-04-18 Thread Michael Kruckenberg
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 hav