Hi, We create a barcode for every order and store them in a folder /barcode. The files are <1kb less .gif's but is there a limit to how many files you can store in one folder? Its running on windows server 2003. Thanks
No there isn't - the only thing limiting it will be your harddrive space, You can use cfdirectory to get the total size of the files in the directory and if it is a certain amount then dont allow any more uploads and upload to another directory if you wanted to manually set a limit
No that's great just checking as we will have 100,000 files in there, just making sure no limitations within windows.
As they are created with a CFX tag that creates them on the FS. why do you feel it would be better to store in mySQL?
The answer to this question depends on what file system your server is using. For example FAT16 has a limit of 65536 (2^16), FAT32 4294967296. I am unsure on the limit for NTFS but I believe it would be similar to FAT32.
I was thinking of portability. I wonder - what's the construct of your cfdirectory tag? Is it faster that an cfquery. Just wondering (taking into account that you can setup indexes on the database)
Well the images are accessed via HTTP. They are only created once with a CFX tag. I think its the best solution to store on the FS.
I agree. As long as you are not transversing (searching) through your directory, you will be fine, and size should have no issue. If you are searching I would consider something else, but since you say you access the files directly through http rather then searching, everything *should* be ok.