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