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 ------------------------------------------------------------------------- ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento ------------------------------------------------------------------------- E S C R I B A I N F O R M A T I C A ------------------------------------------------------------------------- The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into "my eyes" Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 ------------------------------------------------------------------------- Reply: [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