> Hello community !!! > > The software house on i'm work want to store images ( TIF FILES +/- > 100kb compressed with gzip ) on database... using InnoDB database... ( > files or raw devices ) > > The discussion is : > > - The innodb ( or myisam ) is sufficient robust to allow store > 10.000.000 images ( with 100kb ) without problems ( corrupt or fail > ) ? > > - If is sufficient robust , the speed to join and get images from > database is not slow ( slow for me is 2 seconds )? > > - The best solution is store images in files ( ex : > c:\images\img000000.tif) or database ? > > > The responses and experience of all community is very welcome ! > > special for Heikki and Monty , what do you think ? store in files or in > database ? > > Please it is very important for my software house !!! > > my preference is into database... but i'm afraid the volume is big... > > MySQL version : 4.0.9 > Table Type : InnoDB > Operation System : Windows ( 98/ME/NT ) and Linux ( 2.4 ) > Disk Types : IDE and SCSI ( depend of volume ) > > > sql,query,urgent,hehe Since you obviously aren't going to search the images themselves there is no reason to put them into a database. File systems are designed for this. I might suggest using an Id field and then split them into subdirectories based on the 1st or last digit of the ID (0..9). This would reduce the number of files in a given directory which can be a problem with VERY large numbers of files. You can also put them on a totally differnet drive from the database data to increase performance. The cost is bit of setup (have to create the directories) and programming. This should allow the database rows to be uniform in size which should help performance.
William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 --------------------------------------------------------------------- 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
