Dion I just discovered your site and was doing some reading here I like your solutions I have read so far, have you ever given any thought into creating a mod that will put attachments into sub folders this is a modification I could really use as I have more than 47k attachments on my site.
Having more than 10k files in a single folder creates all kinds of problems when it comes to backing up and or moving the files. Not sure if you have ever tried to manage 47k+ files in one directory or not but its constant problems at every step of the process, in theory it should not be a problem until you try to do it then you discover the true limitations of the computer systems your working with server side and at home, its a stress test every step of the way, time outs, stalls, what should take an hr to accomplish sometimes turns into all day finding a solution.
Their have been attempts at this in the past but their never seems to be a polished finished project, seems soon as the author meets his personal needs the project stalls (hooray for me well good luck to you thing).
One solution I have been looking at is https://www.phpbb.com/community/viewtop ... &t=2130170 I tried it in the early days of development but ran into problems and getting support then was not good I put off the idea in hopes PHPBB would finish it and make it a new feature of PHPBB I get the impression developers at PHPBB could care less since they never experience the problem.
Since I first started using PHPBB back in 2003 I have always felt a great resistance to attachments when seeking support.
I think its time I finally address the 47k files in one folder issue since PHPBB is not before I waste a bunch of time contacting my host having them create a backup of my "Files" directory with the 47k+ files, downloading it verifying all the files are their then testing the mod on my home server http://www.uniformserver.com I figured I would ask here first.
Its obvious you have considerable skills where as I don't, I can follow direction and have a good attention to detail I just need the "for dummies" version lol
My needs are to put attachments into more than one folder each folder should have less than 10k files, I was thinking 9500 files per folder, I have tested with working with 9500 files in a single folder and while I found some slow downs I have not run into timeouts yet.
Sorting if not a big deal I would like them sorted chronologically so as time goes on newer files are put into newer directories, when one directory reaches 9500 files a new one is created then the files are put into the newest directory.
I don't have any concerns about older directories meaning once a directory fills to 9500 files then say 1000 files are deleted off the PHPBB site having a older folder with 8500 files in it. Chances of 1000 files being removed is unlikely.
Any thoughts on this I like your outside the box approach to things, I have found a very inside the box approach on the PHPBB site and it appears to be a very tightly sealed box so no thinking can happen outside when it comes to attachments.
Thanks in advance.