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:

http://doc.silverstripe.com/doku.php?id=recipes:customising-the-hierarchy&s=sitetree%20grouping

Before you get into hacking the core, I'd recommend moving the whole thing over to model admin, if I were you. That interface is much better suited for the amount of data you're working with.

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.

.... that is if I can make it work. . . .

Try your best to do it with decorators, specifically using augmentSQL(), that way you'll insulate your changes and be able to upgrade when new versions of EC come out.