Re: [DFW CFUG] best way to store images / photos in an application

[derek bumpas]

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:
>  List@list.dfwcfug.org
> 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: 
  List@list.dfwcfug.org
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/