+1 For medical imaging, at least in radiology (PACS), you usually see the terabytes of images being stored on a NAS somewhere, and the database itself is actually pretty small just pointing to filenames of where the pictures are located. This keeps the database small and fast, and lets you add storage without the complication of using Logical Volume Management since you don't need to extend your filesystem to add space. Just add a completely new block of space and start writing your images out to it, storing the location in a field in your DB.
On Tuesday, September 24, 2002, at 08:46 AM, Salada, Duncan wrote: > You can store pictures in a BLOB field, but it is generally > recommended that > you simply store the filename of the picture. > > -----Original Message----- > From: Roland Perez [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 24, 2002 9:35 AM > To: [EMAIL PROTECTED] > Subject: Store pictures in DB > > > Can I use MySQL to store pictures as part of a record? > Should I just try to store the name of the picture? > > Thanks for any help > Roland Perez > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php