Re[2]: Storeing images in Database
Dobrý den, sexta-feira, 24 de janeiro de 2003, 22:41:47, napsal jste: WRM> Since you obviously aren't going to search the images themselves there is WRM> no reason to put them into a database. File systems are designed for WRM> this. I might suggest using an Id field and then split them into WRM> subdirectories based on the 1st or last digit of the ID (0..9). This WRM> would reduce the number of files in a given directory which can be a WRM> problem with VERY large numbers of files. You can also put them on a WRM> totally differnet drive from the database data to increase performance. WRM> The cost is bit of setup (have to create the directories) and WRM> programming. This should allow the database rows to be uniform in size WRM> which should help performance. OK , but my database is only for images... and i want integrate my client application with the Internet page around the world ... What is more easy, one select and get image or a connection to download the image ? The point is this. in my case... the images in sql database is more comfortable , but is it secure ? you loose data using BLOB fields ? please send me a reply to help me in my decision :) The suggestion bout ID in database and store an a file system, it is very interesting , but if i loose the id´s ? atomically i loose the images correct ? Tanks in advance ! sql,query,tnks - ++ 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" look: cannot open my eyes - 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
Re: Storeing images in Database
> 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\img00.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
Storeing images in Database
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\img00.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
