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

Reply via email to