I need to figure out a way to setup folders beneath of the "Calendar of Events" page so "Events" can be organized. Currently there are around 200 events in the system and it will only grow. I've created child pages inside of 'Calendar of Events" to house the "Events" and am going to dig in and figure out a way to make it work. Currently the "Events" disappear from the site as soon as they are put in a folder - which makes sense because they are no longer direct children of "Calendar of Events".
Basically I need to use all Grand-Children of "Calendar of Events" rather than all Children.
If anyone has some ideas that'd be great. Otherwise I'll be posting the results of my efforts here.
This is my biggest qualm with the design of Silverstripe. The SiteTree model is just not scalable. Fortunately, they are very well aware of this and there are some ideas floating around. See "Dyanmic Grouping" here:
Yes, I agree that to do this the 'right' way is a big undertaking. I am going to do it a much more 'hackish' way by modifying the DB queries - It will strain the DB more, but traffic won't be huge so it should be an OK fix for a while.