I will store it as CLOB or BLOB in Oracle to gain performance if picture quantity is more than thousand.
http://www.dba-oracle.com/t_blob.htm -- Max derek bumpas <[EMAIL PROTECTED]> wrote: Hi Kevin, I think your photo storage solution will depend on how many photos you will be storing. If you are talking thousands, I would break them up and group them under subfolders (alphabetically or something). Some OS's (windows) have issues with large numbers of files in a single folder. Also, you don't need to use cffile to get your images, you could just link to the image directly with a dynamically built path. Naming conflicts are easily fixed by coldfusion on the upload, or you can create new names (GUID's work well). Derek On Dec 17, 2007 3:51 PM, Kevin <[EMAIL PROTECTED]> wrote: I was wondering what the brilliant minds out there would say about storing photos for an application. If we have users that are going to be uploading their photos what would you suggest? 1. Rename the photo using an 'photo' table which assigns a unique id to each photo and store all photos in one directory 2. Store the photos in a different directory for each user and use cffile to retrieve the photos 3. <another option /> Thoughts? -------------------------------------------------------- Kevin Fricke Lone Star Media [EMAIL PROTECTED] Office: (512) 371-1822 Mobile: (512) 626-0528 Fax: (512) 597-0909 Toll Free: (877) 791-7083 http://www.lonestarmedia.com _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/ _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
