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
