This is an OK solution for a small number of images. Most filesystems (unix/linux et al included) have a severe time penalty in opening a known file in a folder when the folder contains many files.
So while easier to hold a reference to a file (filename) it will become slower when your number of files gets large. Next step using files is to use many folders, but then this provides its own problems. I have a small database (growing) of just over 400,000 images. A perl cgi program gets the imags on the fly and outputs them without creating files and is _very_ fast. M -----Original Message----- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 14:27 To: Rochester, Dean Cc: mysql Subject: RE: How does one put images into a MySql database You can put images in the DB, but the easiest way is to put the path to the images in a text field, and rely on the disk to send the images. hope that helps, Brian -----Original Message----- From: Rochester, Dean [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 7:50 AM To: MySQL (E-mail) (E-mail) Subject: How does one put images into a MySql database Greeting all Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql database? I have done this with OLE objects using MS Access... can this be done using the blob data type some how? Thanks in advance Dean-O --------------------------------------------------------------------- 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
